Hello All

I'd like to ask if following is possible and if so, how it can be set up.

1. Case insensitive searching.
Actually I know this possible but I don't know how to properly configure
the dataset for this capabilty.
Say I have a table for customer list that has (among others) two columns:
- short_name which is the primary key for the table
- full_name - a varchar(250) column

What should be the optimum scenario to achieve case insensitive
searching on these two column - additional columns in the table with
upper case content or additonal column in the select statement
representing upper case content.

2. 'Containing' like searches without stars (*).
I am fully aware of using stars characters when specifying search
criteria and I use them a lot. But I wonder if it possible to tell IBO
to search with 'containing' or 'like' predicate without using stars.
Lets get back to the table from point 1.
Now user, when searches for a record where certain field might contain
specified text, he uses stars as brackets. It works great. But the user
complains about using stars. Can we set up the dataset somehow that it
always use 'containing' predicate?

3. 'Or' searching
Possible at all?
If I put two edits binded to same column IBO will 'and' both criterias.
How can I tell to 'or' them?


Thanks in advance
Marcin