concatenate number fields

[greentank]

I have two number fields 1 called prefix (sample data 087) and the other called number(sample data 1234567). I have a third field which I want to contain 353 then contents of prefix without the 0 and finally the contents of number.

[Søren Dyhr]

Pretty straight forward typecast as long as you return the result of the calc'field as text:

353 & Int ( prefix ) & theNumber

--sd

[greentank]

I need the new field to be a number though - any ideas?

[Vaughan]

GetAsNumber( ) will do the trick.