Hey all,
Heres 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
