Sql server LIKE '%%'

Like sql

WHERE CustomerName LIKE 'a%'	
--Finds any values that start with "a"
WHERE CustomerName LIKE '%a'	
--Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'	
--Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'	
--Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a__%'	
--Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'	
--Finds any values that start with "a" and ends with "o"

103

Sql server LIKE '%%'

select * from Employee 
where last_name Like '%a%'

Similar codes

0 vote313 views3 answers
Create and attach user to a postgresql database
SQL
3 votes301 views1 answer
Two selects in one query
SQL
1 vote322 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote323 views2 answers
Starts and end with vowel sql
SQL
0 vote329 views1 answer
Oracle grant create job
SQL
1 vote299 views1 answer
Oracle apex prevent initial load
SQL
-1 vote308 views1 answer
How to switch user in mysql
SQL
0 vote340 views1 answer
Manage Database in MySQL
SQL
0 vote286 views1 answer
Select other columns with distinct
SQL
18 votes315 views3 answers
Mysql add column with default value
SQL