Hi Samuel,

... WHERE field in ('RAW','WIP','FGD')
... WHERE field LIKE '%RAW%' OR field LIKE '%WIP%' OR field LIKE '%FGD%'

Note: if your DB server is case-sensitive you must uppercase(field): UCASE(field) LIKE '%WIP%'

MartinJ

>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 VFP, I can use "FGD" $ item_type, but it does not
>accept $ in SQL syntax.
>Can you help?