Home Forums SQL Server 2012 SQL Server 2012 - T-SQL select only up to first '-' only RE: select only up to first '-' only
Koen Verbeeck
SSC Guru
Points: 259085
More actions
December 10, 2013 at 12:15 am
#1672214
SELECT House_no
FROM myTable
WHERE CHARINDEX('-',House_no,CHARINDEX('-',House_no,1)+1) = 0
ORDER BY House_no
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP