SQL Column Concatination

[Scuzy]

Im trying to combine several fields into one single field previous to a INSERT INTO call. I have tried the following statement "Select Field1+Field2+Field3 AS NewField from table" and the NewField gets created but it is empty. Any Ideas??

[bashfirst]

Could it be a data type problem? Should your concatenation character be a & or | | instead?
Bash