Link to home
Avatar of MFC123
MFC123

asked on

converting string to only alphanumeric chars using SQL UDF

Hello Experts,

Is it possible to write an SQL UDF  that takes a varchar input and coverts it to alphanumeric only? i.e the return String from UDF should contain only alphanumeric.

If it is possible then can you please prodive me the code snippet?

Thanks !
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of MFC123
MFC123

ASKER

Thanks much. It worked like a charm!