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

4 votes266 views4 answers
Remove duplicate old value in mysql
SQL
13 votes243 views5 answers
Sql default
SQL
0 vote258 views3 answers
Run sql command line
SQL
1 vote200 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
34 votes233 views6 answers
Install mysql client ubuntu
SQL
0 vote220 views1 answer
Java mysql date format
SQL
21 votes231 views3 answers
Average sql
SQL
2 votes246 views1 answer
How to get weekday from old date in sql
SQL
0 vote305 views1 answer
Python get backup of sql
SQL
6 votes251 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