Matthew Walker wrote: > You can't apply max() to a text datatype. So how about: > > SELECT MAX(LEN(CAST(textdatafield AS nvarchar(4000)))) > > If the result is < 4000 then it will work. If not, it won't. Or you > could use varchar(8000).
and you can only stored 8000 bytes in varchars in a row total, you can define more than 8000 in the table, but once the total bytes stored in a row reaches 8000, ms sql server throws and error.. pretty huh? this something that doesn't happen with oracle :-) z ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
