>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

select table1.field1 from table1 ;
   where table1.field2$table1.field1

Tamar