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.