MS-Access Memo fields

[petermaci]

Hi:

Wondering if anyone knows how to manipulate the returned text in an MS-Access memo field so that '\r\n' can be replaced with '<br />'. The problem is that the ODBC_result function (ODBC driver) is removing these characters from the named field after it is returned to me. So I am trying to replace these characters at the same time I am requesting it. But there seems to be no Replace() function in MS-Access SQL, because it gives and error when I try this:

SELECT REPLACE('memo', '\r\n', '<br/>') as changed FROM database.

Any help or pointers would be appreciated.
PeterMac

 

[aschi666]

why don't u just replace it with php after selection?
there are even multiple regex-implementation, check "ereg" on

http://www.php.net

__________________________________________
a programmer is a tool that converts coffee into code...
aschi666, sthcomputing.de

 

[petermaci]

because the \n\r are stripped out of the data when it is retrieved. I sent the result to a file and even looked at it in HEX and they are gone. No 0D 0A... nodda...

Peter