Sign in
Anthony Bloesch's Web Log
A WebLog about SQL Server development.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tags
architecture
bugs
bulk load
connect
Developers
dog-food
equality
Error handling
feedback
forums
fragmentation
hash index
Hierarchies
IDataReader
instead of trigger
Intellisense
keyboard
lifecycle
Microsoft
Microsoft Oslo
Modeling Services
Oslo
paging
performance
refactoring
Repository
row_number
Security
shortcut
SQ Server
SQL
SQL Server
SQL Server Modeling Services
SQL traces
SqlBulkCopy
style
top
trailing spaces
Trees
T-SQL
unique
Unique constraint
uniqueness
versioning
view
Windows 7
Browse by Tags
MSDN Blogs
>
Anthony Bloesch's Web Log
>
All Tags
>
trailing spaces
Tagged Content List
Blog Post:
Testing strings for equality counting trailing spaces
Anthony Bloesch
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...
on
20 Feb 2009
Page 1 of 1 (1 items)