SQL Query to Enclose Column with Quotes When it Has a Pipe Character

Using Conditional Statements to Perform Multiple Updates in a Single SQL Query: A Practical Approach