[snip] The problem is that I want to stick with standard SQL. I would assume that convert() is a MS SQL Server function, and, thus, not standard (will not work in other database formats).
Did what you read mention why the data was being truncated? Perhaps if I knew why, then I could fix it. [/snip] Since this is not a PHP issue may I refer you to http://msdn.microsoft.com ? You will find a truckload of information there as well as tons by searching Google for 'Microsoft SQL Server column types' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php