Your REPLACE() was perfect except for the "space period" still resulted in a stop. Will have to find another character to go there (or just remove the period, that may...

Ah, gotcha. That makes sense.

Any idea why this wouldn't pick up the pattern above then?

(CAST(CAST(sNoteText AS varchar(MAX)) AS VARBINARY(MAX)) LIKE '%0A2E0A%' OR CAST(CAST(sNoteText AS varchar(MAX)) AS VARBINARY(MAX))...

I don't think that's all encompassing though. While terrible formatting, a new line, a period, and some text wouldn't lead to this problem. So I need a way to find...

Any way to pick that up with a RegEx of some kind perhaps?

Looks like my problem sequence (for now) is 0A2E0A. Not sure why the CHAR(13)+CHAR(10) sequence didn't pick it up and I can't get the VARBINARY(MAX) to pick it up either....

So I've been trying to write a query for now to just detect this issue. The problem is the newline, period, newline sequence is appearing inside other text (it's a...

Potentially. What suggestions do you have?

I have reviewed that in detail and will be re-posting shortly. Thanks for the tips.

In this third table, I'd be getting data for SubAcct='SUB1' AND for the value in the SQLClause column. So in other words, it has an Account and SubAcct column in...