ToName

ToName removes all non-numeric and non-alphabetic characters from a string. Underscores are not removed.

Syntax

ToName(<input_string> [,<retain_chars>])

Input_string is the source string to modify.
Retain_chars appends to the list of characters to keep.

String

n/a

select '123S.n,o~o!p@y$$%^&456' as orig,
ToName('123S.n,o~o!p@y$$%^&456')
from Empty();

select '123S.n,o~o!p@y$$%^&456' as orig,
ToName('123S.n,o~o!p@y$$%^&456', '!$')
from Empty();

select 'Keeps_underscores__    yeah' as orig,
ToName('Keeps_underscores__    yeah')
from Empty();