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 vote342 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote348 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote377 views1 answer
Sqlite3 update select
SQL
0 vote365 views1 answer
Mysql cli output to a file
SQL
27 votes431 views3 answers
Mysql delete row
SQL
22 votes348 views4 answers
Show list of users in mysql
SQL
0 vote358 views2 answers
Mysql dump structure only
SQL
17 votes364 views3 answers
Postgresql version command
SQL
0 vote368 views1 answer
Sql server remove enter from string
SQL
2 votes358 views1 answer
Node and mysql like
SQL