I am getting seriously peed off with this 'should be simple, but isn't' question...

I have FieldA and FieldB, I want to output to fieldC in a table.

ie. I want to run some type of SQL statement that will save me from having to go through each record in a mahooosive database...

I have JAN in FieldA and 05 in FieldB I want to populate FieldC with JAN05

and if FieldA is FEB and FieldB is 110 I want to populate FieldC with FEB110 etc etc...

It should be easy, believe me I have tried all sorts.

I have tried a simple INSERT INTO STATEMENT, I have tried all kinds of configurations of this, I have tried the UNION route and also in my desperation I have tried an Append query, which would never work anyhow, I just can't get it to play ball.

I would appreciate it if any of you computer bods could help out.