Topic complex |
Selecting |
Function |
LIKE |
Short |
String comparison with wild cards |
Syntax |
Exp LIKE Pattern |
Parameter |
Exp : String
Pattern : String with "?" and "*" as Jokers |
Return |
TRUE, if Exp matches with the search pattern
FALSE, otherwise |
See also: |
|
Description |
In the search pattern a "?" means exactly one any desired char, "*" means any number of those chars (also 0).
"Müller" LIKE "*er" -> TRUE
"Müller" LIKE "M?ll*" -> TRUE
"Müller" LIKE "M?ller?" -> FALSE
|