cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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.

0 Likes
View Entire Topic
mari_outtaleb96
Participant
0 Likes

HI clas.hortien,

thanks for the answer, but this solution just if I have one character to replace but I have a lot of characters in my table.

For example :

RACCORD INOX UNION A/S 1"

PLAQUE A BUSE 399422 60µ

SOND PT100 Ø 6MM AVEC CABLE 3FILS

Regards.