> SELECT Employee.*
> FROM Employee
> WHERE UpperLastName = 'CAILLOUET'
>
> becomes
>
> SELECT Employee.*
> FROM Employee
> WHERE LastName = 'CAILLOUET'

Can I shout "VIEWS!"

select ...
from employee_v
where last_name_search = 'CAILLOUET'

Then, port the view so that "last_name_search" simply
points to the "normal" (propercase) column and with
Firebird, to it's shadow column.

> The problem comes from the Employee.* which will return
> your ugly upper case data. But everyone knows that the
> beauty of relational databases is the independence of
> program logic from the physical layout of the database -
> adding a field to a table doesn't break applications
> unless you use the asterisk wild card. Since no professional
> programmer would ever use that in anything but a sample
> program... Sorry. That's one of my crusades against
> SQL....

There's more to crusade against :)


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."