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

LIKE Pattern

Wildcard Explanation ?

Answer
WildcardExplanation
%Allows you to match any string of any length (including zero length)
_Allows you to match on a single character
[ ]Allows you to match on any character in the [ ] brackets (for example, [abc] would match on a, b, or c characters)
[^]Allows you to match on any character not in the [^] brackets (for example, [^abc] would match on any character that is not a, b, or c characters)

Question

LIKE Pattern

Wildcard Explanation ?

Answer
?

Question

LIKE Pattern

Wildcard Explanation ?

Answer
WildcardExplanation
%Allows you to match any string of any length (including zero length)
_Allows you to match on a single character
[ ]Allows you to match on any character in the [ ] brackets (for example, [abc] would match on a, b, or c characters)
[^]Allows you to match on any character not in the [^] brackets (for example, [^abc] would match on any character that is not a, b, or c characters)
If you want to change selection, open document below and click on "Move attachment"

SQL Server: LIKE Condition
] Parameters or Arguments expression A character expression such as a column or field. pattern A character expression that contains pattern matching. The patterns that you can choose from are: <span>Wildcard Explanation % Allows you to match any string of any length (including zero length) _ Allows you to match on a single character [ ] Allows you to match on any character in the [ ] brackets (for example, [abc] would match on a, b, or c characters) [^] Allows you to match on any character not in the [^] brackets (for example, [^abc] would match on any character that is not a, b, or c characters) escape_character Optional. It allows you to test for literal instances of a wildcard character such as % or _. Example - Using % wildcard (percent sign wildcard) The first SQL Server LI

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.