Concat

[Cadteach]

I'm trying to combine 2 fields into 1 new field using concat. This is what I using

UPDATE 'idxactrs' SET 'idxactrs.desc' = concat(remarks1,remarks2)

It just says "You have an error in your SQL syntax near ''idxactrs' ...

Any Ideas?

 

[ericbrunson]

You're using unnecessary and wrong quotes.

 

[Cadteach]

Solved..

Thanks, used

SELECT CONCAT( Remarks1, Remarks2, remarks3, remarks4, remarks5, remarks6) AS Descri
FROM IdxactRs;