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 vote191 views1 answer
Radius search with point data in mysql
SQL
0 vote145 views1 answer
Postgresql using reserved word as column name
SQL
0 vote155 views1 answer
Define a variable in mysql from select
SQL
0 vote137 views1 answer
Apt install sql server
SQL
0 vote132 views1 answer
Oracle index hint multiple tables example
SQL
0 vote138 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote134 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote139 views1 answer
Mariadb errno 121
SQL
1 vote136 views1 answer
Primary key with prefix sql
SQL
0 vote137 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL