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?
Cadavre
SSC-Forever
Points: 41690
More actions
October 25, 2013 at 6:48 am
#1661609
Could do something odd like this: -
WHERE Names = STUFF(Names,1,1,'A')
That'd tell you if the "Names" started with an A.