How to remove spaces from value in column.

[jeisch]

I have a column in a table that contains values with spaces include. Ex "12 F7 35". I need to remove all spaces from this column. It needs to be "12F735". I tried using translate, but that seems to only translarte from one character to another, it won't actually remove the space.

Thanks

 

[MarcLodge]

Hi Jeisch,

Try the REPLACE function swapping a space for nothing, like this:

SELECT REPLACE ('12 F7 35', ' ', '')
FROM SYSIBM.SYSDUMMY1

Hope this helps,

Marc

 

[jeisch]

Thanks, That worked.