...
Building on the query above, this statement will find carriage returns and new line characters and remove them using the Replace function:
Note: chr(10) is a line feed; chr(13) is a carriage return
with recs as
(SELECT
ie.instance_hrid,
...
...
Building on the query above, this statement will find carriage returns and new line characters and remove them using the Replace function:
Note: chr(10) is a line feed; chr(13) is a carriage return
with recs as
(SELECT
ie.instance_hrid,
...