Enbedded SQL Question

Thomas,

You wrote:

but in query you can in the where clause with like

Field             Test   Value (Field, Number, 'C
TKPERSON          LIKE   '%4957%'
Is there somthing equivalent to that in SQL?
I think when I used Sequel way back they had 'Contains' for that kind
of search.
Im not finding an answer to this in my SQL book so thought you guys
would know if its possible.<<

Not sure what you mean by "in query".    Sounds like you are talking
about it as a product vs. a general statement as in "a query".

The LIKE function is basic to SQL so you can use it.

You said "...when I used Sequel way back they had 'Contains'..."   

While I've seen it used as well as a synonym for LIKE, when you are
talking SQL, the only place I've see it used is in PROCEDURES on the
i5.

HTH,

Dave Odom
Arizona