Complex search for a String

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. Received on Tue Aug 08 2000 - 00:00:00 CDT