I'm pretty certain you are not allowed to use regular string functions on *text* data types in MS SQL 2000.
If you want to check for length, try this: IF (DATALENGTH(@text_var) > 0) ~Brad -----Original Message----- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 11:43 AM To: CF-Talk Subject: Re: CF SQL question Kris, Inequality <> works just fine for MS SQL Server TSQL for versions 2000 and 2005. Teddy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
