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+unsubscr...@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
