Hello,

is the following a known limitation, as designed or a bug?

* The following queries uses an UPPER index on NAME:

select * from accommodation where upper(name) like 'ARC%'
select * from accommodation where upper(name) starting with 'ARC'
select * from accommodation where upper(name) starting with upper('arc')


*But the following does not:

select * from accommodation where upper(name) like upper('arc%')
select * from accommodation where upper(name) like upper('arc')


Thanks!

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com