Hi
I am converting a database from Access to Base, however I am having problems finding out how to search the data ignoring the case of the text.
Looking it up online shows that you used to have to select a table type as VARCHAR_IGNORECASE but this does not seem to be an option anymore.
can this still be done?
Thanks
If you are using embedded Firebird database this might be helpful: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-chartypes.html#fblangref25-datatypes-chartypes-caseinsenstv . Table field type VARCHAR_IGNORECASE is a type of embedded HSQLDB, which is still available but considered deprecated.
The SQL LIKE operator is not case sensitive by default, so it may be of use to you.
Note that LIKE allows SQL wildcard tokens, which may need special attention in some situations (when the search term includes percent, square brackets or underscore, mostly).
See this info page about Access vs. SQL wildcards.
Thanks for the ideas I will try them out.
Cheers.