Re: SQL Query

In article <319A4927.41C67EA6_at_openmarket.com>, Shuzi Chen <chen_at_openmarket.com> 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 [].

If you wish to return ONLY the 3 values listed, try:   select * from test where name in ('help','hell','hely') This should give you what you want if you're not looking for wildcard matches.

David Scott                        ...how can I keep from singing?
                bumper snicker: My other guitar is a Martin (D16H)