Query Help - How to concatenate multiple fields in a query

#1 · December 26, 2020, 10:11 am

Here is a query that shows a great example of multiple concatenate statements used to combine information, add a space inbetween each attribute, that can then be used to an Item Description. You can take this example and use if for just about anything.

SELECT ($[OITM.U_Schedule] || ' ' || $[OITM.U_OD] || ' ' || $[OITM.U_Mattype] || ' ' || $[OITM.U_Size] || ' ' ||$[OITM.U_Grade]) as "Name"
FROM DUMMY
;

Enjoy!