Re: [SQL] how do I check for lower case

2006-08-10 Thread Oisin Glynn
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 int

Re: [SQL] how do I check for lower case

2006-08-10 Thread Scott Marlowe
On Thu, 2006-08-10 at 15:32, 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 a

Re: [SQL] how do I check for lower case

2006-08-10 Thread Daryl Richter
On 8/10/06 4:32 PM, "Juliann Meyer" <[EMAIL PROTECTED]> 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 l

Re: [SQL] how do I check for lower case

2006-08-10 Thread Rodrigo De León
On 8/10/06, Juliann Meyer <[EMAIL PROTECTED]> 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

[SQL] how do I check for lower case

2006-08-10 Thread Juliann Meyer
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 tha