> From: Olivier Poulet <[EMAIL PROTECTED]> > Date: 2004/08/07 Sat AM 09:39:59 GMT > my $sql =<<'EOFSQL'; > SELECT > LOWER(field_one)
as field_one
>, field_two, UPPER(field_three)
as field_three
> FROM sample_table (NOLOCK)
> WHERE
> field_one = ?
> EOFSQL
That should do it...
HTH,
amonotod
--
`\|||/ amonotod@ | sun|perl|windows
(@@) charter.net | sysadmin|dba
ooO_(_)_Ooo____________________________________
_____|_____|_____|_____|_____|_____|_____|_____|
