While I have your attention, do you have any suggestions on how I can query on a value with a single quote in the middle of a string of text?

Going back to this particular report, the one column that I had setup in that dataset is a varchar(max) data type and has a set of single quotes in the middle of the text. Ex: This is the day 'it is supposed to start to warm up' and look nice outside.

Now, if I were querying on that specific string, I would just use 2 single quotes on both ends to escape the special character such as:

'This is the day ''it is supposed to start to warm up'' and look nice outside.'

But in this case, I don't know where the single quotes will be positioned. As well as I'm passing the string to a parameter (variable) such as @TEXT.

I wrote a function to remove the quotes from that column but that takes a while to complete and new data will be loaded in the table every week. I will have to re-run that function every week.

Just wondering if there is a better way to handle a situation like this.

Thanks!