SQL How to find records based on CAPITAL and small letters in SQL Query? - 01.06.18 | 30.08.20 - ErcanOPAK comment on How to find records based on CAPITAL and small letters in SQL Query? SELECT * FROM SQLTABLE WHERE SUBSTRING(TableColumn, 1, 1) = ‘x’ COLLATE SQL_Latin1_General_CP1_CS_AS Read More