SQL question

[Tim Davis]

Hi Greg,

> What SQL code can be used if I want a query to find a specific word (or
> words) within a string of words? In other words I want know if a field
> contains (not =) a string.
>
> For example I have a field with the string: "SQL is not as simple as 
> you
> think".  I would like this field to appear as a result if make a query 
> using
> the keyword "SQL" or "simple" or "not as simple" etc.


Select Field1 From MyTable Where Field1 Like 'simple' no_case

No_Case is an option.
When you use "Like", you will need to escape GREP characters, and 
Valentina has a function for that. (Just escape apostrophe otherwise.)

Tim Davis