Details
Details
Assignee
Unassigned
UnassignedReporter
Brad Wood
Brad WoodLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Priority
Created 2 September 2022 at 14:49
Updated 2 September 2022 at 15:34
This QoQ works to concatenate strings, (so long as they aren’t both numbers!)
SELECT 'foo' + col FROM myQry
but this falls back to HSQLDB
SELECT 'foo' || col FROM myQry
https://www.webucator.com/article/how-to-concatenate-strings-in-sql/