how to get rid of special character

[barrysaab]

I have a list report and my native database is teradata,the problem i am encountering i am getting a output like PDAS?ASGRACI?M   when i run a report for product name.Please note that i have varying length product name ,I have tried

substring(character_length(description)) and SUBSTR(LENGTH(COLUMN)-4) Both giving me error.Please help.Thanks

[adik]

substring(column from x to y) or substring (column, x, y) - this is the terradata substring function

[barrysaab]

Thanks adik but my character length is not fixed.

[adik]

i'm not sure how it is in teradata world, but in oracle i would try something like this
substr(column, instr(column, character, start position, nth apparence) + 1, instr(column, character, start position, nth apparence + 1)))