I tried something like this:
CAST(replace(m.Description, vlbf, ' ') AS VARCHAR(8000))AS "Product Description",
and tried variations of vlbf such as chr(10) chr(13) or \r\n and none of them worked.
I can't put them in single quotes as SQL will look for the actual occurence in the string rather than what it stands for.
I get the error column vlbf is unknown or chr(10) is an unknown function....
|