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 vote172 views1 answer
Alter table name including schema
SQL
2 votes106 views1 answer
Pandas to sql index
SQL
0 vote115 views1 answer
Empty table sqlite
SQL
0 vote115 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
28 votes121 views6 answers
Foreign key
SQL
1 vote184 views1 answer
Adding a check statement in sql
SQL
0 vote105 views1 answer
How to select all fieldsin a soql query
SQL
24 votes114 views4 answers
Postgres delete database
SQL
0 vote120 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote140 views3 answers
Select top 10 rows in sql
SQL