Thanks for the help, though. I guess I'll scrounge around elsewhere.
Jay Blanchard wrote:
[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'
-- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php