> is it possible to use parameters within the select statement?
>
> Something like
>
> "select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE"

Yes, but I guess you will get an error at prepare time.

You explicitely have to specify what data type the :PATH parameter is,
e.g. with:

select cast (:PATH as varchar(255)) || FILENAME as filepath from SOME_TABLE


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/