clean up database

[yxez]

Hi Friends,

I want to clean-up my EMP table with some garbage encoded by the users.
One of the affected column is ENAME. I found garbage values like

ENAME
--------
AAAAAA
BBBBBBB
CCCCCC

I want to update this field to null if a certain letter repeated 3x or more
starting from position 1. Can you help me please.

Another thing is, how do I check if ENAME contains any small case letters?
For example.

ENAME
-------
JENnY LOPeZ


Thanks a lot

[LKBrwn_DBA]

For 3 or more letters:

Where SUBTR(ENAME,1,1) = SUBTR(ENAME,2,1)
  And SUBTR(ENAME,1,1) = SUBTR(ENAME,3,1)

For Mixed case letters:

Where ENAME != UPPER(ENAME)

[yxez]

Thanks a lot dear ....I just feel God's love everyday to hear helping people like you, Praise HIM and more blessing to all and more power to this forum.