Truncating and appending records in a table in Access 1

[rsmith904]

I have variable length data that need data appended to the end of the record. I'm using a select statement. I got a syntax error when using:

SELECT trim(trailing from Global Address List.E-mail address) || '@usaid.gov', [Global Address List].First, [Global Address List].Last, [Global Address List].Company,
FROM [Global Address List]
WHERE ((([Global Address List].Company) Like "xxxx/IG/*" Or ([Global Address List].Company) Like "*RIG*"));

I would appreciate any help.

 

[PHV]

In JetSQL the concatenation operator is & instead of the ANSI standard || and the Trim function has a much simpler syntax:
SELECT Trim([Global Address List].[E-mail address]) & '@usaid.gov', ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886