query text on base

users
#1

I'm starting to use base, reading help I found:

Examples
='Ms.'
returns field names with the field content "Ms."

and

Querying text fields
To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't see it that strict).

It seems that I can query this fields

abcd
asdf
sadr
erte

with 'a' and obtain

abcd
asdf
sadr

but it doesn't works and it seems I have to use LIKE '*a*' to obtain

abcd
asdf
sadr

is this the correct behaviour or it is a bug??
  if it is the correct behaviour in the help I think it should be something like this "returns field names where the field IS "Ms.""

is the LIKE command the correct way to find a portion of text in the field??

what I have to use to have a non case-sensitive query??

manythanks, ciao, pier :slight_smile: