256 char limit from query

[kirkm]

I'm querying a text field and a memo field in my table.

sql = "Select Serial & Lyrics AS SL from tbl1956 Where Serial Like '7400*';"

The result is the first 256 characters, then garbage. I can fix this by " Select Serial, Lyrics from..." but wonder if there's any other way around it. Or does a calculated field have a 256 limit ?

 

[pr2-eugin]

Allen Browne, has written a small article about this : http://allenbrowne.com/ser-63.html