Re: how to change the case from lowercase to uppercase ?

From: PD <pavvel_at_post.cz>
Date: Fri, 7 Apr 2000 14:38:15 +0200
Message-ID: <8ckktm$g6j$1@scesie13.sie.siemens.at>

update <table> set <column> = upper<column>; commit;

---

Pavel Drs
ANF Data
Pavel.Drs_at_anfdata.cz

<newnewbie_at_my-deja.com> píše v diskusním příspěvku:8cbsmt$r3d$1_at_nnrp1.deja.c om...
> i have 2,000 records in the database which is in lowercase.
>
> how can i update these records to be uppercase without deleting them
> and adding them again ?
>
>
> thanks for reading my post.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 07 2000 - 07:38:15 CDT