Re: SQL HELP

Geoffrey B Milord (gemilord_at_red.seas.upenn.edu) wrote:
: Does any one know how do the following:
: select * from table
: where name like 'lower(&1)%'

try

select * from table
where name like lower(&1)||'%'

--
 
John Blackburn                           Phone: +61 7 32534634
jb2_at_qdot.qld.gov.au                      Fax:   +61 7 38541194

"Please enclose a stamped, self-addressed ethernet packet with
 all correspondence..."

#include <std_disclaimers.h>