Hi,

> I thought I had a handle on when to use the colon. I just reread a section
> in the Data Definition Guide; Just so I understand, I only need to use the
> colon on variables if they are inside a select..from...into statement?

Yes, or WHERE clause etc...
Everywhere where you would use a parameter put there a colon in the front of
a variable.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81