[RBG7-L] - Re: NOTE FIELD

[William Owens]

Razzak
I tried this and i got a message something to the effect that i wasn't
allowed to use expression with note fields

Bill
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak
Memon
Sent: Wednesday, August 11, 2004 9:36 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: NOTE FIELD


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.