[libreoffice-users] query text on base

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 :-)

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted