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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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