Re: Complex search for a String

Frank,

If you want a fast and simple way to do it, you could enhance the database with OMNIDEX advanced indexing using a grouping option on all the columns. Then do a SELECT on one of the columns in the group, and it would locate all the SMITHs for you. For more information, see http://www.disc.com/keywords.html or contact me.

Cheryl Grandy
cgrandy_at_disc.com
303 444-4000
www.disc.com/home

In article <8momkm$i6i$1_at_reader1.imaginet.fr>,   "Franck HUGOT" <fhugot_at_globalimmo.org> 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.
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com http://www.deja.com/
Before you buy.