concat for numbers

[Jon Ready]

Hi,

I am interested in performing a concat for numbers with a space
e.g.
select concat (num1, ' ', num2) from tablex as numconc

such that if num1 is 123 and num2 is 456 the result would be '123 456'

I believe concat should work for a string rather than number format, however having created the fields num1 and num2 in string format it still does not work.

Any advice on why this isn't working, or an alternative method to achieve the result would be most welcome.

Cheers,
Jon