Returned limited characters from a memo field

[CestusGW]

I'm using a BASISplus 8.? Database which I believe is SQL2 compliant. I need a command that will limit the number of characters that get returned from a memo field to 255. I have tried the following command but havent gotten it to work:
convert(varchar(255), DBASE.MEMO_FIELD)

Thanks in advance

 

[fluteplr]

Have you tried left or possibly substring

as in select left(memo_field,255) from sometable

what happend with convert?

 

[tlbroadbent]

How about CAST(DBASE.MEMO_FIELD As varchar(255))? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.