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, 1334🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...