• Richard Tatterton (6/24/2010)


    This is what I absolutely hate about SQL Server. A string is a f**king string, no matter whether it's got spaces on it at the end.

    Jeez.

    While this is true.... a string is a string, but the deviation here is the method used to evaluate the strings. Part of the ANSI standard is to make strings evaluated with "=" the same length before comparison and this is not a requirement for pattern matching. Like uses pattern matches so the string does not have to be equal.