Collections:
LIKE - Matching a Pattern in a Character String in SQL Server
What To Perform Pattern Match with the LIKE Operator in SQL Server Transact-SQL?
✍: FYIcenter.com
Pattern match is a very important operation for search records base on character string columns. SQL Server 2005 offers the LIKE operator to perform pattern match operations in two formats:
target_string LIKE pattern -- Returns TRUE if the target string matches the pattern target_string NOT LIKE pattern -- Returns TRUE if the target string does not match the pattern
Pattern match is a powerful operation. But you need to remember several rules:
Here is a simple example of LIKE operator:
SELECT CASE WHEN 'FYIcenter.com' LIKE 'FYI%' THEN 'Pattern matched.' ELSE 'Pattern not matched.' END; GO Pattern matched.
⇒ Using Wildcard Characters in LIKE Operations in SQL Server
⇐ IN - Testing Value in a Value List in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1350🔥, 0💬
Popular Posts:
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...