Re: how do I check for lower case

Juliann Meyer wrote:
> I have a table with a column, lets call it identifier, that is defined 
> as varchar(8) that should never contain lower case letters.  Its a 
> large table.  Is there a way to query the table to see if any values 
> in this column are lower case and to get a list out?  The user 
> interface application that users use prevents them from adding an 
> entry in lower case  now, but didn't in earlier version.
> Julie
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>   

Not sure if  this is over simple  and perhaps this would be a concern on 
a very large table but 

select * from table where identifier <> upper(identifier);

would give a list of all where the entry is not all uppercase?

Oisin