SQL How to find records based on CAPITAL and small letters in SQL Query? - 01.06.18 | 30.08.20 - ErcanOPAK SELECT * FROM SQLTABLE WHERE SUBSTRING(TableColumn, 1, 1) = 'x' COLLATE SQL_Latin1_General_CP1_CS_AS Related posts:How to return only the Date part from SQL Server DateTime datatypeUpdate Column with row_number() in SQL"ORDER BY" with CASE and UNION in SQL ServerNot Null check on LEFT function with T-SQL Post Views: 137