Do you happen to know how to remove a Carriage Return and or line feeds from a field when selecting for reports.
In the mm2po.sdesc field some of our users have entered the following:
Cancelled PO. Processed invoice through A/P.
When trying to use this in a report it really messes things up. I would like to pull it to one line instead of having 2 CRs that puts it on different lines.
I have tried the select replace(mm2po.sdesc,ascii char(13),) but that did not seem to solve the problem.
Any ideas you have would be very apprecaiated.