SQL Validation error Server 7.2

[markbeardhome]

I have some sql code that was working in a report, after upgrading from 6.3 > 7.2 comunity version I now get an validation error.

I have tracked this down to  this section of code

regexp_replace(replace(customer.accounts_note,',',''), E'[\n\r]+', ',,', 'g' ) as reg_rep

if I change the \n\r for something else all is ok. where is this turned off as I have to remove blank lines from my output

any help would be good