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:Update Column with row_number() in SQLHow to get the first and the last day of previous month in SQL ServerCreate, Alter, Drop and Execute SQL Server Stored ProceduresHow to return only the Date part from SQL Server DateTime datatype Post Views: 137