BAQ equivalent to Concatenate

Does any wise soul know what the correct syntax is to create a calculated
field in a BAQ equivalent to Excel "Concatenate" where one of the included
values is numeric?
I can create a field "string(fielda + fieldb)" OK if both fields are
character but get an "incompatible data type" error if one of the fields is
numeric.
TIA
Regards,
Richard

Richard Bailey
Dudley Industries
Mailto: rbailey@...
Tel: +44(0)1253 738311
Mob: +44(0)7836 550360
Fax: +44(0)870 7628173



[Non-text portions of this message have been removed]