Re: SQL Query

Shuzi Chen wrote:
>
> How to write the SQL like the following?
>
> select * from test where name like 'hel[ply]'
> it will return the records which name is help, hell or hely.
> Sybase can do exactly like the above. I do not think the Oracle supports
> the [].
>
> Thanks in advance.
> --
> ----------------------------------------------------------------------
> Shuzi Chen
> chen_at_openmarket.com

there is a function know as Soundex() try that:

Select * from test where soundex(name) = soundex(help);

This will return results sounding like help.

-- 

Muhammad A. Malik
mamalik_at_cs.wmich.edu
+1 (616) 342-4569