>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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.