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?

  • 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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **