Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.


  • Presentation
  • Question
  • Answer

Question
This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.
Answer
SELECT *
FROM employees
WHERE secret_hint LIKE '123!%455' ESCAPE '!';

This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.


Question
This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.
Answer
?

Question
This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.
Answer
SELECT *
FROM employees
WHERE secret_hint LIKE '123!%455' ESCAPE '!';

This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.

If you want to change selection, open document below and click on "Move attachment"

SQL Server: LIKE Condition
character in the SQL Server LIKE condition. You can do this using an Escape character. Please note that you can only define an escape character as a single character (length of 1). For example: <span>SELECT * FROM employees WHERE secret_hint LIKE '123!%455' ESCAPE '!'; This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455. Here is another more complicated example using escape characters in the SQL Server LIKE condition. SELECT * FROM employees WHERE secret_hint LIKE 'H%!%' ESCAPE '!'; This SQL Server LIKE

Summary

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.