Skip to content

Instantly share code, notes, and snippets.

@b2977053

b2977053/string_function_PATINDEX.sql

Created December 13, 2019 10:18
Show Gist options
  • Save b2977053/1940edf6d7f4ea188a49fb44d841f47d to your computer and use it in GitHub Desktop.
Save b2977053/1940edf6d7f4ea188a49fb44d841f47d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
string_function_PATINDEX.sql
PRINT PATINDEX('%en_ure%', 'please ensure the door is locked'); --8
PRINT PATINDEX('%ein%', 'Das ist ein Test' COLLATE Latin1_General_BIN); --9
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment