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]

Hi,

if you have SQL Server 2017 or higher you can use the translate function from here.

"Returns the string provided as a first argument, after some characters specified in the second argument are translated into a destination set of characters, specified in the third argument."

Nice example can be found here.

Regards

Clas