Patrick LeBlanc learns about string concatenation in Spark SQL:
Using PySpark in Azure Synapse Analytics and found that my regular way of concatenating two strings in T-SQL didn’t work. I figured out what you need to do to make this work.
Click through for a short video.