How do I concatenate two fields in a select statement with extra charcaters
? the following all throw errors.

SELECT Field1 + '(' + Field2 + ')'
FROM Table;

SELECT Field1 & '(' & Field2 & ')'
FROM Table;

SELECT Field1 + "("+ Field2 + ")"
FROM Table;

SELECT Field1 & "(" & Field2 & ")"
FROM Table;

SELECT CONCAT(Field1,Field2)
FROM Table;