Re: Enforcing Case

On Thu, 2002-08-22 at 13:08, JDK wrote:
> On Thu, Aug 22, 2002 at 04:47:53PM +0100, paul butler wrote:
> >
> > >  have a small single table database that multiple people enter data
> > > into, and I do some reporting from.  I would like to be able to force
> > > everything to upper case because currently it seems that ABCD or abcd
> > > or AbCd are all treated as unique, and it cause me problems in
> > > reporting, not to mention it makes me nuts seeing the data in the
> > > tables all inconsistent like that.
> > >
> > > How would I force everything to upper case?
> >
> > Would using the upper function work?
> >
> > for your data entry query
> >
> > insert into table (field) values (upper(value));
> >
>
> OK, this worked nicely for my needs.  Is there a command that I
> could run that would convert my existing data to all uppercase?
update table set field=upper(field);


>
> Thanks,
> jdk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749