devxlogo

Concatenating Fields

Concatenating Fields

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.

devx-admin

Share the Post: