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?

  • October 25, 2013 at 6:47 am

    #1661607

    HanShi (10/25/2013)

    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.

    Bear in mind thet LEFT and SUBSTRING will not use any suitable indexes (possible performance issues) whereas LIKE will.

    Far away is close at hand in the images of elsewhere.
    Anon.