Query to insert a field in the beginning of another

[MTSPEER]

Hello,



I have to fields Field1 and Field2. The table name is called Table1. I'm trying to figure out how to Insert Field1 into the beginning of Field2 with a space in between so it is all one sentence. For example if Field1 is someone's name like "Mark", and Field2 is "is a professor". Trying to combine them to show "Mark is a professor" in Field2. Is there a way to make this in an update query?

Thank You

[Rawb]

It would probably be better to create a calculated Column in a SELECT Query that does this. That way you're not continually modifying your data (and adding Field1 to Field2 over and over and over).

SELECT Field1 & " " & Field2 AS CalculatedField
FROM Table1

[MTSPEER]

I just need all the information in the same table.

[Rawb]

It already is in one Table...

But if you're set on doing it that way, then this should work:

UPDATE Table1
SET Field2=Field1 & " " & Field2

Or, if this is something that could potentially be run more than once, you will want to check fields to see if you've already combined them:

UPDATE Table1
SET Field2=Field1 & " " & Field2
WHERE NOT Left(Field2, Len(Field1 & ""))=Field1

[MTSPEER]

Thanks so much!