puiu91
3/18/2016 - 2:03 PM

MSSQL searching for a substring

MSSQL searching for a substring

samples.sql
content_copyfile_download
SELECT COUNT(id) AS countOfId
FROM tableName
WHERE LEFT(district, 1) = 1
    
SELECT COUNT(id) AS countOfId
FROM tableName
WHERE SUBSTRING(district,1,1) = 1
    
SELECT COUNT(id) AS countOfId
FROM tableName
WHERE CHARINDEX('1', SUBSTRING(district,1,1)) > 0