Wildcard - will match anything with keyword in it: WHERE whatever LIKE '%keyword%'
Anything beginning with keyword: WHERE whatever LIKE 'keyword%' Anything ending with keyword: WHERE whatever LIKE '%keyword' Basically % = match any # of characters _ = match single character [] = match set of characters Need to use these with care as they will case a performance hit depending on how many records you need to chug through jim On Thursday, January 24, 2002, OFAH wrote: OW> I am having troubles searching fields in my database for "Like" situations. OW> I have to type in the word (this case e-mail address) exactly as it is in OW> the database or else I get a 0 back, even if I leave off one letter. Now I OW> have done this before (a long time ago). Can someone refresh my memory. is OW> it the Where EMail Like '#SearchEMail#' or something like that? ______________________________________________________________________ Get Your Own 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=coldfusionb 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
