SQL for converting a CHAR(15) field

[legend8]

Hi all,
I'm wondering if it is possible to do the following with DB2:

Trim and remove all the special charaters (including spaces) in a CHAR(15) field so that it contains only characters like A-Z and 0-9. For example:

' AB 123-456' converts to 'AB123456'

Can this be done in DB2 SQL?
Any idea is appreciated.

Legend8

 

[ARWinner]

Yes, I believe it can be done.
Look at functions:
TRANSLATE, POSSTR, RTRIM, LTRIM, SUBSTR

Andy