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 vote290 views1 answer
Sql server alter table add column tinyint
SQL
1 vote265 views1 answer
Mysql query bulk insert
SQL
9 votes293 views3 answers
Postgres make sql dump
SQL
6 votes276 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote261 views1 answer
Drop specific row postgresql
SQL
0 vote268 views1 answer
What alter does in db
SQL
1 vote261 views1 answer
Install postgresql on raspberry pi
SQL
0 vote279 views1 answer
Find how many tables in database sql query
SQL
-2 votes289 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes327 views1 answer
Cannot return non-composite value from function that returns composite type
SQL