Convert Memo to Text 1

[alectek]

Hi!
I need to convert Memo field to Text field using Query.
The function {fn CONVERT (table1."field1", SQL_CHAR} returnig the Error.

Thanks a lot for any help.
Al.

 

[Golom]

This looks like SQL Server syntax. Should you be posting in forum183? This is the Access/JET SQL forum.

 

[alectek]

Golom,
yes, I need it in Acces.
I've table with the memo field and I need the same table with the text fields.

thanks.
Al.

 

[Steve101]

You can use the Left() function in Access to reference a memo field and convert it to a string, though of course you'll be truncating it if its beyond the max length of a string (1K i think).

eg. MyString = Left(MyMemo,1024)

In SQL, simply refer to Left(MyMemo,1024); this will allow string operators to be applied to the expression.

HTH

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)