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.

 

INSERT INTO tbl_name (FieldC) VALUES(tbl_name.FieldA . tblname.FieldB) WHERE tbl_name.FieldA='JAN' AND tbl_name.FieldB='05';

What about that?

 

Cheers for the info fella....

It turned out to be

UPDATE tblname SET FieldC = FieldA & FieldB