[SOLVED] Access function LIKE
lazarus / 16-Databases

----------------------------------------------------------------------
madref · 2016-09-14 22:28

In access you can add Like '* .... *' to your query
When i try this with SQLite like this:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i    cSQL :=
'SELECT * FROM qry_Seizoen_Overzicht_Leden WHERE ((Sei_ID=:Sei_ID) or
:Sei_ID=0)';  if Edit_Naam.Text <> '' then    cSQL := cSQL + ' AND
Achternaam like "*' + Edit_Naam.Text + '*"'; it doesn't work.


How can i do this in SQLite?

----------------------------------------------------------------------
engkin · 2016-09-14 22:49

Replace * with %, I guess.

----------------------------------------------------------------------
shobits1 · 2016-09-14 23:47

https://www.sqlite.org/lang_expr.html#like
QuoteA percent symbol ("%") in the LIKE pattern matches any sequence
of zero or more characters in the string. An underscore ("_") in the
LIKE pattern matches any single character in the string. Any other
character matches itself or its lower/upper case equivalent (i.e.
case-insensitive matching). Important Note: SQLite only understands
upper/lower case for ASCII characters by default. The LIKE operator is
case sensitive by default for unicode characters that are beyond the
ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ'
LIKE 'Æ' is FALSE. The ICU extension to SQLite includes an enhanced
version of the LIKE operator that does case folding across all unicode
characters.
SQLite doc: https://www.sqlite.org/lang.html