Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/How to find rows which contain single character

Created November 14, 2018 14:29
Show Gist options
  • Save arekgotfryd/ac8a50207fa9c9658534b823106af167 to your computer and use it in GitHub Desktop.
Save arekgotfryd/ac8a50207fa9c9658534b823106af167 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
How to find rows which contain single character
SELECT [SUBURB]
,[COLUMN_TYPE]
,[HEIGHT]
,[COLUMN_MATERIAL]
,[OUTREACH_ARM_LENGTH]
,[LUMINAIRE]
,[LAMP_TYPE]
,[LAMP_COUNT]
,[LAT]
,[LON]
,[ADDRESS]
,[POINT]
FROM [Demo].[dbo].[output] where lat like '%[a-z]%' or lon like '%[a-z]%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment