> I am having troubles searching fields in my database for > "Like" situations. I have to type in the word (this case > e-mail address) exactly as it is in the database or else > I get a 0 back, even if I leave off one letter. Now I have > done this before (a long time ago). Can someone refresh > my memory. is it the Where EMail Like '#SearchEMail#' > or something like that?
The percent sign is what you use to match zero or more characters in SQL. If you want to find matches that begin with your string, use this: WHERE Email LIKE '#SearchEMail#%' If you want to find matches that contain your string, use this: WHERE Email LIKE '%#SearchEMail#%' Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
