Home Forums SQL Server 2008 T-SQL (SS2K8) How to Identify name starting with a specific letter without using like operator? RE: How to Identify name starting with a specific letter without using like operator?
HanShi
SSC-Dedicated
Points: 33506
More actions
October 25, 2013 at 6:20 am
#1661597
Why do you have the restriction of using the LIKE operator?
But you can accomplish this for example by using the LEFT or the SUBSTRING operator.