Re: SQL HELP

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

Another alternative is

SELECT * FROM table
WHERE name LIKE LOWER('&1.%');

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!