SQL Update -
10-20-2003
, 09:29 AM
Hello;
Stats: MSAccess 2000
How do I do the Following:
Replace all of the occurrance of a string with a
<CarriageReturn/LineFeed> in a memo field using a SQLUpdate statement
TIA
ALlan
Note
in another DB it I did it this way
UPDATE table 1 SET field1 = REPLACE("<LB>" WITH #13+#10 in field1) |