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

-1 vote283 views5 answers
Online sql to linq generator
SQL
0 vote308 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote290 views1 answer
Foreign key type uniqu mysql
SQL
1 vote269 views1 answer
Crontab every month
SQL
0 vote237 views1 answer
Postgres delete where id in
SQL
6 votes330 views3 answers
Check if string contains substring sql
SQL
0 vote275 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
27 votes301 views5 answers
Mysql set password for user
SQL
1 vote288 views1 answer
Mysql get domain from url
SQL
1 vote293 views1 answer
How to subtract from the value of a table in sql
SQL