Hi Ron, If your field is of type char or varchar the limit is 255 (limited by the db library from Microsoft). If you are using the text type you can use these settings in php.ini ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 128000 ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 128000 You can set both of these from the script with the ini_set() function (http://us4.php.net/ini-set). - Frank > 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