HELLO ALL,

URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE.

FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY
and the CITY column records will be: Newyork
washington
dallas
New jersey
Texas.... and so on.... many records will be there in this CITY column,

Both the lower case and also the record which starts with UPPER CASE like 'NewYork '
should retrieve and delete from the one column in one particular table.

Thanks in anticipation!!!