J
John Clark
Here's the query for replacing linefeed (only) with carriage return,
line feed.
-jdc
--
John Clark
(e-mail address removed)
(o) 718.802.1044
(c) 917.331.8999
line feed.
-jdc
If not, does someone have the syntax of an update query that would
replace the LF characters within a text field with CRLF pairs?
UPDATE tablename
SET fieldname =
REPLACE([fieldname], Chr(10), Chr(13) & Chr(10)) WHERE fieldname LIKE
"*[!" & Chr(13) & "]" & Chr(10) & "*";
John W. Vinson [MVP]
--
John Clark
(e-mail address removed)
(o) 718.802.1044
(c) 917.331.8999