I appologize if this has been answered--haven't found it in the docs, wiki or mail archive.
I have a text column with the following text value in it: c:\Temp\Temp1\Audit1.log I'm trying to figure out how LIKE works. When using the following patterns, I get the following results: '%audit%' match '%\audit%' non-match '%\\audit%' non-match (need a different escape sequence??) '%1\audit%' match (guess don't need an escape sequence after all) '%temp1%' non-match -- huh? '%Temp1%' non-match '%\Temp1%' non-match '%Temp1\%' non-match '%p\Temp1%' match -- starting to think it can't start or end with \ (except temp1 case above) '%p\Temp1\%' match -- wrong again '%p\Temp1\a%' match What I'd like to do is let someone enter an arbitrary piece of a filename path and find matches. I'll start experimenting with GLOB, but I expected LIKE to be able to do this. Can someone help me understand the finer points of LIKE? Thanks Doug ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
