Well, in Oracle, it'll interpret that as matching everything. For example: SELECT sysdate FROM dual WHERE 1 like '%'
On 3/30/07, Scott Stewart <[EMAIL PROTECTED]> wrote: > Hey all, > > > > Here's a weird questionÂ… > > > > We have a query that uses like in the where clause. The like variable is > passed dynamically. > > Where x like #arguments.blah#%. If nothing is passed via arguments.blah, the > where clause looks like this > > > > "where x like %" > > > > How does T-SQL interpret this? Or does it just ignore the clause.. > > > > Thanks, as always.. > > > > sas > > > > > > > > Scott Stewart > ColdFusion Developer > > HYPERLINK > "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=7241+Jillspring+Ct&csz=Sprin > gfield%2C+VA.+22152&country=us" \n7241 Jillspring Ct > Springfield, VA. 22152 > > > HYPERLINK "mailto:[EMAIL PROTECTED]" [EMAIL PROTECTED] > HYPERLINK "http://www.sstwebworks.com"; \nhttp://www.sstwebworks.com > > > tel: > mobile: > > HYPERLINK > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-912-3076&Email=s > [EMAIL PROTECTED]" \n703-912-3076 > HYPERLINK > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-220-2835&Email=s > [EMAIL PROTECTED]" \n703-220-2835 > > > > > > HYPERLINK > "https://www.plaxo.com/add_me?u=25770055805&src=client_sig_212_1_card_join&i > nvite=1" \nAlways have my latest info > > HYPERLINK "http://www.plaxo.com/signature?src=client_sig_212_1_card_sig"; > \nWant a signature like this? > > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.446 / Virus Database: 268.18.22/739 - Release Date: 3/29/2007 > 1:36 PM > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
