The absence of a direct equivalent to SQL's "like" operator has plagued me for some time, so in Lil v1.40 I decided to introduce a first-class equivalent. Using this operator, we can now perform the same type of case-insensitive search (as well as quite a few handy variations) without needing a helper function:
ex:insert Date Entry with 20210412 "Once Upon A Time" 20220709 "There once were" 20230101 "stars upon thars" end select where ((list "%l")format Entry) like "*upon*" from ex # +----------+--------------------+ # | Date | Entry | # +----------+--------------------+ # | 20210412 | "Once Upon A Time" | # | 20230101 | "stars upon thars" | # +----------+--------------------+
If you prefer the previous way, it will be necessary to rename the "like[]" helper function, since "like" is now a reserved word. Sorry for any inconvenience!