Using Length field in DB2 SQL

Khwairakpam Raju Singh · New User Joined: 05 Dec 2007 Posts: 29 Location: Bangalore

Hi All,
Could anyone help me out to form a SQL query for the following requirement?
I have a requirement where in I have to set the value of a column to space if the length of value present in the field is not equal to 2.

e.g.: the Value present in the field (say col_A) of a table (say tab_A) is 'A03' or 'A' then I have to update the value as space. On the other hand if the value is 'AB' (2 byte length). Then I have to keep as it is.

Please suggest me how to do in SQL. Thanks in advance.

Craq Giegerich · Posted: Mon Jul 26, 2010 9:19 pm

Is this column defined as varchar?

GuyC · Posted: Mon Jul 26, 2010 9:25 pm

if col_a is varchar then
update ... where length(col_a) <>2
else
update ... where length(strip(col_a)) <> 2 (if you define "length of value" as number of characters without trailing spaces )

Khwairakpam Raju Singh · New User Joined: 05 Dec 2007 Posts: 29 Location: Bangalore

Oh!! Due to some misunderstanding, I was trying with LEN(), and I got and error.

now its working with the LENGTH() fuction :-) Thanks a lot for you help