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

3 votes50 views2 answers
Sql random integer
SQL
1 vote53 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote55 views1 answer
Oracle webcenter content search enginer
SQL
8 votes56 views1 answer
Oracle search code in packages
SQL
0 vote51 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
-1 vote51 views1 answer
Sql syntax create timestamp column
SQL
2 votes47 views1 answer
Oracle current date without time
SQL
0 vote59 views1 answer
Linked server delete openquery
SQL
10 votes55 views1 answer
Oracle dba_dependencies
SQL
0 vote56 views1 answer
Array aggre distinct postgres
SQL