Re: SQL HELP
From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1995/11/20
Message-ID: <48okm8$j5u_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1995/11/20
Message-ID: <48okm8$j5u_at_inet-nntp-gw-1.us.oracle.com>#1/1
gemilord_at_red.seas.upenn.edu (Geoffrey B Milord) wrote:
>Does any one know how do the following:
>select * from table
>where name like 'lower(&1)%'
>Thanks
select * from table
where name like lower('&1') || '%'
/
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Received on Mon Nov 20 1995 - 00:00:00 CET