> So, you have two choises.
> So, is there a reason to push that last field at all?
> Maybe you should tell us, why you think you need to produce this

on the

> server, and we can help you with your real problem, instead of

discussing

> simptoms of it...
>
> Regards,
> Steffen

Actually,I am passing the select query to my custom search grid.It
is designed in that way(accepting query as the parameter)& it will
show the result of the query .

eg:
SQL=select dt_start,dt_end,dt_start||' - '||dt_end SHAM from
year_setup
(*dt_start,dt_end are date types)

when i pass the "SQL" to my custom search grid,it will show the
records. There is no formatting in my grid,so I should format it in
the query itself. The above query worked well in oracle,but in
firebird the concatenation making prblms.
So if the only way is to use any UDF,pls give the necesary codes for
that.