Multiplying column with a variable

Is there a way for me to do this within a query ?

SELECT NAME
, ID
, VALUE*:MULTIPLIER AS NEW_VALUE
FROM SOME_TABLE
WHERE VALUE>0

No, not with parameters, but you can create stored proc and inside dynamicaly create sql statement and call execute statement (see post Variable table name in Select/Insert in Trigger/Store Procedure? for example)

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
TAMP R&D Team
FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/