![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Help me Lazyweb!
Feb. 28th, 2012 09:51 amI need your help. I am trying to find a function in SQL to replace carriage returns/tabs/whatever when I run a select statement from a table. The column type is a Memo. I do not want to removce them from the actual entry, just from the return and replace them with a space character.
So far, nothing I have found seems to be working.
(and yeah, I'm using ancient versions of SQL and ASP)
For an explanation, I have the following:
*SELECT Blah1, Blah2, Blah3, BlahDate, Comments FROM TehDataBase where yadda LIKE yadda and such and stuff*
The Comments column is a Memo field. People have entered data using commas, CRs, etc...
I am pulling the data into a CSV, and am getting some rather whacked-out results from that column. I just need to strip the return of *Comments* to replace the CR/LF/Tab/comma and replace them with, say, a dash or a period or something.
Au Secour SVP? Anyone? Beueler?
So far, nothing I have found seems to be working.
(and yeah, I'm using ancient versions of SQL and ASP)
For an explanation, I have the following:
*SELECT Blah1, Blah2, Blah3, BlahDate, Comments FROM TehDataBase where yadda LIKE yadda and such and stuff*
The Comments column is a Memo field. People have entered data using commas, CRs, etc...
I am pulling the data into a CSV, and am getting some rather whacked-out results from that column. I just need to strip the return of *Comments* to replace the CR/LF/Tab/comma and replace them with, say, a dash or a period or something.
Au Secour SVP? Anyone? Beueler?
