Re: Complex search for a String

Franck HUGOT wrote:
>
> Hello,
>
> I would like to search a String in all columns of a table.
> I know I can do :
> select user_name from usertable where user_prenom='smith' or
> user_ville='smith' or user_alias='smith' or ....
>
> Is there a more simple way?
>
> Thanks in advance.

where instr(col1||col2||col3||... , 'string') > 0

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse