Re: How to search on a column without using LIKE?

John Smith wrote:
>
> A Developer asked me if there's a way to search within a column without
> using LIKE.
>
> For example, there is a column called 'ORG_NAME' which contains a value
> (for example):
>
> 'STANS WIDGETS AND FLANGES LTD'.
>
> He wants to be able to enter a query using any of the words in the name,
> i.e. STANS, WIDGETS, FLANGES without having to code WHERE ORG_NAME LIKE
> 'STAN%' OR WHERE ORG_NAME LIKE '%WIDGETS%' OR WHERE ORG_NAME LIKE
> '%FLANGES%' etc.
>
> He did suggest having a separate table which contained a foreign key on
> the parent table for each of the words, i.e.
>
> ORG_ID WORD
> 1 STAN
> 1 WIDGETS
> 1 FLANGES
>
> It would probably work but is a bit clunky.
>
> Any ideas?
>
> Thanks,
> Andy Horne

In what sense is this "clunky"?
This is the normalised form of the data and is generally recommended.

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"