ToQwerty

ToQwerty is a data scrubbing function that removes all non-QWERTY characters from a string.

Syntax

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

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

String

The list of QWERTY characters includes:

Digits:

0123456789

Uppercase Letters:

ABCDEFGHIJKLMNOPQRSTUVWXYZ

Lowercase Letters:

abcdefghijklmnopqrstuvwxyz

Punctuation and Symbols:

~`!@#$%^&*()_-+={[}]|\\:;\”\'<,>.?/

select 'q常w用e漢r字tҘyҠ' as orig,
ToQwerty('q常w用e漢r字tҘyҠ')
from Empty();

select 'q常w用e漢r字tҘyҠ' as orig,
ToQwerty('q常w用e漢r字tҘyҠ', '常')
from Empty();

select 'q常w用e漢r字tҘyҠ' as orig,
ToQwerty('q常w用e漢r字tҘyҠ', 'Ҙ常')
from Empty();