KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
If I deliberately store trailing spaces in a VARCHAR column, how can I force SQL Server to see the data as mismatch? SELECT 'foo' WHERE 'bar' = 'bar ' I have tried: SELECT 'foo' WHERE LEN('bar') = LEN('bar ') One method I've seen floated is to append a specific character to the end of every string then strip it back out for my presentation... but this seems pretty silly. Is there a method I've overlooked? I've noticed that it does not apply to leading spaces so perhaps I run a function which inverts the character order before the compare.... problem is that this makes the query unSARGable....
Tags (comma-separated)
Save Edits
Cancel