Riho-Rene,
You might try substituting CONTAINING for LIKE to broaden the search. For instance,
if I am looking for every name that contains 'john' I use: SELECT name from
table where name containing 'john'
Every occurrence of a name that contains the substring 'john' is returned.

I don't know if this is as efficient as the LIKE operand.

Thanks,
Hugh Johnson

>Hi Riho-Rene,
>
>> Is it somehow possible to do a search like this:
>>
>> select (name1 || name2) as name from table
>> where name like 'test'
>
>That doesn't work, but this does:
>
> select (name1 || name2) from table
> where name1 || name2 like 'test'
>
>
>BTW
>If you use 'like' like this, I think it behaves as '='
>
>> I want to search some part of name from both fields - I dont know
>> what part of data is in first or in second field. if name1="abcdef"
>> and name2="ghij", then I could find the record if I serched for 'cd'
>> or 'hi'
>
>
>Greetings,
>Paul
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

>
>
>