>There is a better way I'm sure:
>
>SELECT field1 FROM table1 WHERE (alltrim(field1) $ field1)
>
>
>>hi all,
>>i have a friend who is trying to do a sql command but is not having any luck. basically he wants to return field1 from table 1 where field2 occurs in field1. i am not great with sub querys but is this easy/possible to do? i suppose it would go something like in pyudocode
>>

>>select table1.field1 from table1 where table1.field2 is found anywhere in table1.field1
>>

>>~M

That would gives you only these records where Field2 is contained in Field1. i.e.

Field1                    Field2
-------------------------------
This is a test             is
This is not included       Test

With your query you will get only first record. That's why I am not sure about the result Mark wants.
(You have a little typo in your query, you check Field1 $ Field1 :o))))
Also I forgot to ask Mark, did he wants case-sensitive searching or not :o)