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??
Printable View
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??
Could it be a data type problem? Should your concatenation character be a & or | | instead?
Bash