SELECT * FROM SQLTABLE WHERE SUBSTRING(TableColumn, 1, 1) = 'x' COLLATE SQL_Latin1_General_CP1_CS_AS
Related posts:
How to return only the Date from a SQL Server DateTime datatype
How to solve "TableAdapter can't see stored procedure returned fields when using temp table" problem
Create, Alter, Drop and Execute SQL Server Stored Procedures
How to enable, disable and check if Service Broker is enabled on a database in SQL Server
How to check column data types of a table in SQL