Hi Duilio

I use a Stored Procedure to fill in a string with zeros. I think you can use
an UDF to do this (I always avoid UDFs)

Email me pvt if you want me to send you the SP.

Artur

----- Original Message -----
From: "Duilio Foschi"
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 26, 2002 12:19 AM
Subject: [ib-support] SQL problem


> I can write this:
>
> update atable set partita=:part_new || cast (singolo as char(8) )
>
> but this gives me something like 'foo1', while I need 'foo00000001'
>
> Any help ?
>
> Thank you
>
> Foschi
>