Help w/ select statement

[ssmith001]

Greetings,

I have data in a column (CHAR(25))that looks like this:

'! A0076D2 '
'! A0078 '
'! A0133CH1 '
'! X245700000 '

How can I select just the text minus the leading/trailing spaces and exclamation point (ie: 'A0076D2', 'A0078', 'A0133CH1', 'X245700000')


Thanks in advance.

Steve

[DreamWarrior]

Look into the substr, rtrim, and ltrim SQL functions.

[patel_dil]

Try this :

select trim(ltrim( your_column, '!')) from your_table;

HTH.