Skip to content

Instantly share code, notes, and snippets.

@wellercs

wellercs/tsql_FindFirstCharacterWithCharIndex

Created July 27, 2012 23:07
Show Gist options
  • Save wellercs/3190937 to your computer and use it in GitHub Desktop.
Save wellercs/3190937 to your computer and use it in GitHub Desktop.
Download ZIP
Searching on first character with CHARINDEX
Raw
tsql_FindFirstCharacterWithCharIndex
DECLARE @AlphaNumChars varchar(50)
SET @AlphaNumChars = 'a,1,m,s'
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE CHARINDEX(LEFT(TABLE_NAME,1),@AlphaNumChars) > 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment