MSSQL searching for a substring
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