deputy dipshit musta been on the loose last night, when I wrote that email ;)
they are there....i was fine....thanks ade! ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 5:39 AM To: CF-Talk Subject: RE: sql wildcards I just tried this on SQLServer7 and it works fine Ade -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 21:35 To: CF-Talk Subject: sql wildcards hey, if I want to find all instances of valid format email addresses in my database, why in the heck, doesn't this show email addresses that begin with numbers? select email from CompanyTable where email like '%@%.%' thanks. tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists