> 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
