update table_name set username = lower(username)
SVRMGR> create table test ( username varchar2(16) );
Statement processed.
SVRMGR> insert into test values ( 'JOHN' );
1 row processed.
SVRMGR> update test set username = lower(username);
1 row processed.
SVRMGR> select * from test;
USERNAME
----------------
john
1 row selected.
At 03:12 PM 11/11/99 -0500, Kelly Hamlin wrote:
>We imported our database of users and info from a VFP database into platypus
>and all is great except for the fact all usersnames and passwords are listed
>UPPERCASe and i need a simple SQL query where i can change username and
>password to all lower case, then i will have everything running smoothly :)
>thanks in advance
>
>Kelly Hamlin
>[EMAIL PROTECTED]
>Network Administrator
>(941) 332.4900
>http://www.neosmart.com
>
>
>===
>Archive at http://www.thesite.com.au/~radiator/
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
