Question:
How do I concatenate a value in Stored Procedures (e.g., select * from mytable, where mytable.field1 = field that I concatenate)?
Answer:
If you want to match field1 to “LoggingLevel” and concatenate “Logging” and “Level” to get “LoggingLevel”, do this:
SELECT * FROM mytableWHERE mytable.field1 = "Logging"||"Level"
The “||” is the concatenation symbol.