Correct - I should have stated that in my original email. Thanks for the clarification.
-----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 3:48 PM To: CF-Talk Subject: Re: SQL "Like" Steve Milburn wrote: > T-SQL will return every record in this case. % is a placeholder for any > characters, so your query would essentially tell the database "where x = any > pattern of characters" and would return everything. .....if there are no NULLs in x. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
