At 07:11 PM 5/4/2005, Karen Tellef wrote:
One difference I noticed between having a varchar and a note column in a table is that if you will be exporting the data (say to an Excel file), you will just get the word [BLOB] for a varchar field, whereas you would get the full note. I searched to see whether there's a setting or option to download varchars any other way but I couldn't find it. So if you need to export a field, then you need to stick with a note field.
Karen,
You can easily convert the VARCHAR data to NOTE data!
Here's how:
Example:
TableA: ColumnA INTEGER ColumnB VARCHAR
TableB: ColumnA INTEGER ColumnC NOTE
Routine to convert VARCHAR to NOTE Field:
INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA
The resulting ColumnC in TableB will include the converted VARCHAR to NOTE.
That's all there is to it!
Very Best R:egards,
Razzak.
