Re: Enforcing Case

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?

Thanks,
jdk