> 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));
It'll be ok for new entries, but you'll have to do some wrangling on
the old ones if they are to remain unique.
Or on the output side
select upper(field) from table
Hope this helps
pgsql-novice by date
|Next:||From: Rod Kreisler||Date: 2002-08-22 15:52:53|
|Subject: Re: Enforcing Case|
|Previous:||From: Chad Thompson||Date: 2002-08-22 15:04:34|
|Subject: Re: Simple but slow|