Hi all,
I wish to select out some matched records in my given condition.
Such as a record has field "item_type" contains "RAW,WIP,FGD"
and some contain "RAW,FGD".... How to select all records matched
with "FGD" ? In Visual FoxPro, I can use "FGD" $ item_type, but it does not
accept $ in SQL syntax.
Can you help?


Use AT() SQL equivalent.

... where CHARINDEX('FGD', item_type)>0

I suggest you to use one surer outline ( a fixed separator out of data domain ):
"item_type" contains ",RAW,WIP,FGD,"

with this you can use variable lenght tags, like RAW and RAWW

"item_type" contains ",RAW,RAWW,WIP,FGD,"
... where CHARINDEX(',RAW,', item_type)>0