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, 1402🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...