Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Why does SQL Server not pull expected results when using strings with comparison operators? RE: Why does SQL Server not pull expected results when using strings with comparison operators?

  • March 1, 2015 at 6:45 pm

    #1781009

    What's wrong with this?

    USE AdventureWorks2012 ;

    GO

    --Returns 5 records

    SELECT pp.Name

    FROM Production.Product AS pp

    WHERE pp.Name LIKE N'Short%'

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service