<<
If you browse to the VarChar field and copy the contents of a
field, then paste
the contents into a text editor that displays the ASCII or HEX
value for the
TEXT of the VarChar, what represents the CrLf value..
>>
Mike:
I did a little more work on the table in question, removing some unused text
columns (I'd kept the original columns I combined until I was sure the new NOTE
columns were working). The result is that the table scan search is now back to
an acceptable speed without changing the column defs in the production database
from NOTE to VARCHAR. For that reason I'm going to drop the issue for the time
being and take it up again when I'm not on the client's clock.
My question remains, though -- what's the correct syntax to set a VARCHAR
column to the concatenation of two TEXT fields with a line end between the
values:
UPDATE Table SET VarcharCol = (TextCol + CHAR(10) + TextCol)
UPDATE Table SET VarcharCol = (TextCol + CHAR(13) + TextCol)
UPDATE Table SET VarcharCol = (TextCol + CHAR(13) + CHAR(10) + TextCol)
UPDATE Table SET VarcharCol = (TextCol + (CVAL("LINEEND"))+ TextCol)
Any insight to share?
--
Larry
