Using a literal string in SELECT statement

Question

Is there an equivalent SOQL syntax to write following SQL?

SELECT Id, 'Northwind Category' AS Note
FROM categories

sfdcfox · Accepted Answer

Unfortunately, we can't provide a literal string. SOQL only accepts fields and a few select formulas in the fields section of a query. This includes aggregate functions (COUNT, MAX, MIN), toLabel, and TYPEOF (in some cases). If you wanted to include a literal value, you'd have to make a formula and select it as a field.

Correct answer by sfdcfox on August 27, 2020

Peter Serafin · Answer

You can use the Case function to get around this. This is not the standard use - but if you really need it then you can do something like this:
SELECT Id,
CASE
    WHEN ID IS NOT NULL THEN 'Northwind Category'
    ELSE 'Northwind Category'
END AS Note
FROM categories

Alternatively when creating a data extension set a default value.

Using a literal string in SELECT statement

2 Answers

Add your own answers!

Ask a Question