Character to Memo

[Valentin Dominguez]

Hi

I have a database with several fields and with 5 character fields. I want to use a Memo field to replace the character fields because the lack of space
How can I import the character field to the new memo field?

Thanks you

Valentin

 

[Tim Ferguson]

=?Utf-8?B?VmFsZW50aW4gRG9taW5ndWV6?= <Valentin
(e-mail address removed)> wrote in

I have a database with several fields and with 5 character fields. I
want to use a Memo field to replace the character fields because the
lack of space How can I import the character field to the new memo
field?

UPDATE MyTable
SET MyMemo = MyCharOne & YourCharTwo & HisCharThree
& OurCharFour & TheirCharFive
WHERE LEN(MyMemo) = 0

Saving space is a really bad reason for messing up a table design, though.
If you are close to the 2GB limit, it is probably time to think about
moving to a stronger rdbms like SQL Server et al. You are going to have to
work much harder to shell the text fields back out of the memo.

HTH


Tim F