Thanks Kurt. I think glob looks promising. best regards -brett
Quoting Kurt Welgehausen <[EMAIL PROTECTED]>: > > How do I search on whole words ... > > find ... "main" and don't want ... "maintain" > > I tried using brackets as specified in the SQL spec > > There are no brackets in the SQL spec; that's a Microsoft extension. > SQLite's glob operator has similar syntax; it's an extension also. > > If your word separators are always spaces, you can use > > col like '% main %' or col like 'main %' or col like '% main' or > col = 'main' > > If there can be other characters between words, you can use > something like > > col glob '*[ ,.]main[ ,.]*' or col glob 'main[ ,.]*' or > col glob '*[ ,.]main' or col = 'main' > > Regards > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.