Hi all. what is the easiest way to combine 2 columns and a string in between. I see that Concat is supported, but not Concat_ws. In the example i want to add a customer name like the following "first name" + ", " + "last name". using "&" or "+" fails. thanks

I've resorted to a nested concat. In my usage: CONCAT(CONCAT(itemsku, ' - '), locationname)

@Stephanie Hughes that works! I tried something similar that failed, but i'll take it! thanks!!!

You can use

||

to concatenate

@jen Agreed, thanks!