Hi, All

I have the following SQL statment intend to search the company name
beginning with a centain value, I have a index based on Name field.

SELECT name, street, city, state, postalcode, country_id
FROM clients
WHERE UPPER(name) STARTING WITH :Value;

The statment returns all correct records with the name starting with
"H" or "h" (if the Value is "h"), but DOESN'T use the name index, so
it is not good.

What is the best way to to make the firebird database engine to pick
the correct index (NAME) to do such kind of searching regardless if
the searched fields are uppercase or lowercase.

Thanks

William