Merge 2 columns into one with UPDATE.
Alright guys, I'm new to this forum and I've been googling for about an hour.
What I am trying to do is (for a database of about 4million records) merge 2 columns:
let's say they are `cola` and `colb`. I need to merge them into `colC` not just for the output (like a concat query), I need them to merge and update into colC.
The reason for this is that I am trying to make it possible to search both colA and colB with 1 string (which for this database, can be a combination of the two).
Hopefully I explained this clearly enough for someone to help.