Anthony Bloesch's Web Log

A WebLog about SQL Server development.

Browse by Tags

Tagged Content List
  • Blog Post: Testing strings for equality counting trailing spaces

    The SQL standard requires that string comparisons, effectively, pad the shorter string with space characters. This leads to the surprising result that N'' ≠ N' ' (the empty string equals a string of one or more space characters) and more generally any string equals another string if they differ only...
Page 1 of 1 (1 items)