Skip to content

Instantly share code, notes, and snippets.

@timotewb

timotewb/checkSpecialCharactersNetezza.sql

Created October 26, 2020 09:05
Show Gist options
  • Save timotewb/982be5fa9a034d6af82cef54156f9dc9 to your computer and use it in GitHub Desktop.
Save timotewb/982be5fa9a034d6af82cef54156f9dc9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
checkSpecialCharactersNetezza.sql
SELECT
CASE
WHEN length(
translate('testing123£$%^4521 with ch*(ars HELP TEST THIS',
' 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
''
)
) > 0
THEN TRUE
ELSE FALSE
END as test01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment