Chapter 14 - SQL SERVER LIKE CLAUSE AND WILDCARDS IN HINDI | CODING ERA
SQL Server Like Operator, Wildcards in SQL Server, Like Operator in SQL SERVER. We can use like operator for pattern search in sql server. There are mainly two types of wildcard often used in sql server, first is % (Percent) which represent one or two or many characters and second is _ (underscore) which represent only one character.
‘a%’ : Find all value starts with character “a”
‘%a’ : Find all value ends with character “a”
‘%a%’ : Find all value that contains “a” in any position
‘_a%’ : Find all value that have “a” in second position
‘a%a’ : Find all value that start with “a” and end with “a”
[] : Represent any single character with in brackets
^ : Represent any character not in brackets
: Represent a range of characters
Chapter 1 - Introduction of MS SQL Server | Create SQL Database | Restore database: • Chapter 1 - Introduction of MS SQL Server ...
Chapter 10 - SQL SERVER INSERT UPDATE DELETE WITH TOP CLAUSE: • Chapter 10 - SQL SERVER INSERT UPDATE DELE...
Chapter 13 - Aggregate Function in SQL Server: • Chapter 13 - Aggregate Function in SQL Ser...
10 Important SQL Server Interview Query: • 10 Important SQL Server Interview Query in...
jQuery Complete Course For Beginners: • jQuery Complete Course For Beginners | jQu...