Re: SQL Query
From: Red devil <lsimon_at_teleglobe.ca>
Date: 1996/05/17
Message-ID: <4nial8$bmd_at_wagner.spc.videotron.ca>#1/1
Date: 1996/05/17
Message-ID: <4nial8$bmd_at_wagner.spc.videotron.ca>#1/1
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 [].
>Thanks in advance.
>--
>----------------------------------------------------------------------
>Shuzi Chen
>chen_at_openmarket.com
Like that:
where name like 'hel_'
but it will of course return other name : hela, helu, ....
Received on Fri May 17 1996 - 00:00:00 CEST