> What was fixed in IBO was the underlying problem of IBO not putting the
> locate query on the server together correctly. When doing that I have to
> take into consideration of the underlying column name because that is the
> data I need to look through. I believe it will allow the locate on either
> the underlying SQLName or the actual AliasName of the column as far as
> identifying what column is being searched against.

Right, I thought "locate" was a client side thing only.

> Obviously, if there is ambiguity that the alias is required to

distinguish,

> then it is the responsibility of the programmer to be sure they do the
> locate based on the alias and not the potentially ambiguous SQLName.

Have you considered the case where there's no column name?

eg:

select 'test', *
from ...

etc?

Imagine "test" coming from some formula or whatever...

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com