db2 script needed to count and delete the data

[abhilash malyala]

Hi Folks,

I need a script to count and delete the lower and mixed case data in one particular field from a table.

example: table name is employee and field name is 'NAME' and data in the NAME
field contains lower case and mixed case.

Thanks and Regards
Abhi

[Intakhab]

Hi Folks,

I need a script to count and delete the lower and mixed case data in one particular field from a table.

example: table name is employee and field name is 'NAME' and data in the NAME
field contains lower case and mixed case.

Thanks and Regards
Abhi

hi,
I think if i am not wrong then
Ur Query will be :
Delete employee where Upper(Name)='SMITH'
or
Delete employee where lower(Name)='smith'

Thanks
Intakhab Alam

[sakumar9]

Yes, you are right. You can use UCASE and LCASE functions in such cases.

[docdiesel]

Hi,

to count the lines where the name is not stored in lower case (means is upper or mixed case) you could use the following query:

SELECT
  count(NAME)
FROM
  employee
WHERE
  NOT lcase(NAME) = NAME ;

Got your sql script ready? What does it look like?

Regards,

Bernd