I sure do have a typo - it was supposed to be:

SELECT field1 FROM table1 WHERE (alltrim(field2) $ field1)

I thought that was what he wanted? I thought he wanted a result of all records where the 2nd field existed anywhere inside the first field. I guess I really misunderstood! (thanks for catching the typo Borislav!)



>>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)