I'm having a problem when users put a carriage return within a memo field.
It's causing problems as I join several memo fields together.
I'd like to know if it's possible to strip out the character for carriage return, from within a query. There are a few issues behind it as I believe it shouldnt be happening but as it's a work issue I need to fix it ASAP.
I think it is chr(13) but I'm not 100% on that.