How to Include Ampersand in String

Summary

How do I use an ampersand in a string

Content

Hi all - we are reviewing a report today and ran across an error that we are not familiar with.  When we create a new BIP report, and paste the code into the Data Set box, sometimes we will receive a message that says ****.  However, today, we pasted our code and receive a message that says "Please enter values for lexical references in SQL-Test" (see screenshot).  We know that this happened because we  had a string of text that has an ampersand in it, but we are unsure how to fix it.  We have a business unit that is