Hey Ron try having a look at the odbc.defaultlrl setting in the ini file i have also found that putting the text column last in the select statment helps best zac -----Original Message----- From: Herhuth, Ron [mailto:Ron.Herhuth@tatumpartners.com] Sent: Friday, December 12, 2003 5:33 PM To: php-windows@lists.php.net Subject: Not returning all text Quick question, I have a field in MS SQL that is returning a very lengthy string of text. When the string is input it is all making it into the database, but when I return it and display the data on screen it is truncating well prematurely. Is there a setting in the ini that limits this? and if so can I change the valu inline (like set_time_limit(120000)). Thanks, Ron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php