>I'm trying to re-structure a table that has a 254-byte notes field and a memo comments field. I need to combine these two into one memo field, IE:
>
>lmNewMemo = lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>
>The "lmNewMemo" field contains just the old memo field.
>
>Any suggestions?
>
>Thanks,
>
>Harry
You can use ALTER TABLE ... ADD COLUMN, add the new memo field, REPLACE ALL lmNewMemo with lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField.
Or in what area did you need suggestions?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)