Re: [SQL] Returning only alphanumeric values from a query

2010/7/26 Enrique Palacios : > HI everyone, > Im new here, this is my first mail and i would like to know how return from > a query only alphanumeric values and these symbols: ().,-% > Something like: > SELECT description FROM products WHERE productid = 5 > RESULT > == > X# PRODUCT %1.0/30(UN)

[SQL] Returning only alphanumeric values from a query

HI everyone, Im new here, this is my first mail and i would like to know how return from a query only alphanumeric values and these symbols: ().,-% Something like: SELECT description FROM products WHERE productid = 5 RESULT == X# PRODUCT %1.0/30(UN) DESIRED RESULT == X PRODUCT %1