MVSFORUMS.com

[CJ]

Hi all,

I have a db2 column defined as character of 50 and it contains the lastname followed a comma and the firstname.Now my requirement is to shuffle the contents of the column to be firstname and a comma and lastname

Name

[kolusu]

Cj,
The following sql will give you the results.I have used the scalar function POSSTR to find the position of the comma and then use the SUBSTR scalar function to move the contents. I also used the STRIP scalar function to remove any trailing spaces. You can remove it if don't require the strip of the blanks

[ajeykumar]

Maybe you could also try it like this:

UPDATE Table_name
SET Column_name = SUBSTR(Col, LOCATE (',', Col), 50 ) || ',' ||
SUBSTR(Col, 1, LOCATE (',', Col))


Didn't get a chance to try it our myself, but it may work

Thanks
Ajey