+ Start a Discussion

SOQL: string concatenation

I could not find anything in the v6.0 API docs on this.

Anyone know if string concatenation is supported in SOQL?

Using Oracle concatenation syntax fails:

select Name || 'Inc.', ID from account

Using MS-SQL syntax (which I think is SQL-92 syntax compliant) also fails:
select Name + 'Inc.', ID from account

Thanks -
Todd Hardin,
Customer Systems Inc.