Collections:
Performing Comparison on Character Strings in SQL Server
How To Perform Comparison on Character Strings in SQL Server Transact-SQL?
✍: FYIcenter.com
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
⇒ BETWEEN - Testing Value in a Range in SQL Server
⇐ Performing Comparison on Date and Time Values in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1403🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...