[RBG7-L] - Re: NOTE FIELD

[A. Razzak Memon]

At 09:12 AM 8/11/2004 -0400, Bill Owens wrote:

I am in the process of converting a dos application to windows. I have a
table with (4) note fields. I am unloading to ASCII file to bring into new
table. Is there anyway I can combine/merge all 4 note fields in one note
field in new table

Bill,

Here's how:

01. Add a fifth note field as NOTE data type, such as AllNotes to your
    existing table

02. Use the following UPDATE command to combine all notes into one:

    UPDATE tablename SET AllNotes = (note1col&note2col&note3col&note4col)

    Now you have the AllNotes with every note from 1-4 note fields.

Notes:

01. Keep in mind that the NOTE data type is limited to 4092 characters.

02. Use VARCHAR data type, if desired.

Hope that helps!

Very Best R:egards,

Razzak.