>
> > > AS
> > > DECLARE VARIABLE V_CUSTOMERPASS VARCHAR(35);
> > > begin
> > > SELECT CUSTOMERPASS /* <=== Here is offending portion */ FROM
> > Customers
> >
> > I assume that CUSTOMERPASS is a field of Customers? Did you use quotes

to

> > generate the DDL for the tables? If so, it would be case-sensitive.
>
> Yes, CustomerPass is a field of the table Customers, but I didn't use

quotes

> and I don't think IBExpert did either or at least, when I look at the DDL
> tab of the Table in IBExpert, its not quoted as I think it would be if I

had

> used quotes. This is what I was curious about.
>

Look at the entry in the RDB$Relation_Fields table to see exactly how it's
entered there. Also, have you tried just entering the query itself in
IBExpert to make sure it works. Just substitute some known values for the
variables.

Woody (TMW)