Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Performing Comparison on Character Strings

By: FYIcenter.com

(Continued from previous topic...)

How To Perform Comparison on Character Strings?

Comparison operations on character strings are performed based on the associated collation. Each collation defines rules on how characters are ordered, how character cases and accents are treated, etc. The tutorial exercise below shows you some character string comparison examples using the default collation: SQL_Latin1_General_CP1_CI_AS.

-- Case insensitive
DECLARE @x VARCHAR(40), @y VARCHAR(40);
SET @x = 'FYIcenter.com';
SET @y = 'fyicenter.COM';
SELECT CASE WHEN @x = @y THEN 'True' ELSE 'False' END;
GO
True

-- digits has less values than letters
DECLARE @x VARCHAR(40), @y VARCHAR(40);
SET @x = '1234';
SET @y = 'abcd';
SELECT CASE WHEN @x < @y THEN 'True' ELSE 'False' END;
GO
True

-- Trailing spaces are ignored
DECLARE @x VARCHAR(40), @y VARCHAR(40);
SET @x = 'FYIcenter.com';
SET @y = 'fyicenter.COM   ';
SELECT CASE WHEN @x = @y THEN 'True' ELSE 'False' END;
GO
True

-- Longer strings have greater values
DECLARE @x VARCHAR(40), @y VARCHAR(40);
SET @x = 'abcd';
SET @y = 'abcde';
SELECT CASE WHEN @x < @y THEN 'True' ELSE 'False' END;
GO
True

(Continued on next topic...)

  1. What Is a Boolean Value?
  2. What Are Conditional Expressions?
  3. What Are Comparison Operations?
  4. How To Perform Comparison on Exact Numbers?
  5. How To Perform Comparison on Floating Point Numbers?
  6. How To Perform Comparison on Date and Time Values?
  7. How To Perform Comparison on Character Strings?
  8. What To Test Value Ranges with the BETWEEN Operator?
  9. What To Test Value Lists with the IN Operator?
  10. What To Perform Pattern Match with the LIKE Operator?
  11. How To Use Wildcard Characters in LIKE Operations?
  12. How To Test Subquery Results with the EXISTS Operator?
  13. How To Test Values Returned by a Subquery with the IN Operator?
  14. What Are Logical/Boolean Operations?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...