At 25/02/2002 08:19 PM, you wrote:

>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 ?

Here is a good example where you can use an UDF. You can create one in
Delphi. I would suggest that you get FreeUDFLib made by Greg Deatz, it has
the Delphi source code that you can study.

Then the UPDATE statement would be:

update atable set partita=yourUDF(:part_new,singolo)

Hope this helps.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)