SQL QUERY (SELECT Characters)

[mari_outtaleb]

Hello,

HOW I CAN ELIMINATE THE SYMBOLS AND KEEP ONLY THE NUMBERS AND LETTERS IN THE RESULT OF MY QUERY SQL?

FOR EXAMPLE example :

From : ML TUBE INOX 316L Ø 27X3MM""

To : ML TUBE INOX 316L 27X3MM

Any ideas?

Regards.

[clas_hortien]

Hello,

this can be done with the replace function like so:

select replace('ML TUBE INOX 316L Ø 27X3MM""','Ø','')

This has to be done for each symbol you want to replace.

Regards

Clas