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 vote173 views1 answer
Ignore case in string sql
SQL
1 vote179 views1 answer
Pl sql insert into table
SQL
0 vote178 views2 answers
How to delete the rows with null values in mysql
SQL
8 votes171 views3 answers
Postgres connection string
SQL
2 votes163 views1 answer
Oracle cpu per session
SQL
4 votes191 views2 answers
REST API
SQL
0 vote172 views1 answer
Find all tables where column name exists oracle
SQL
0 vote135 views1 answer
Mysql workbench search all tables
SQL
1 vote180 views1 answer
SQL date part only of datetime
SQL
1 vote168 views1 answer
Drush sql-dump
SQL