256 char limit from query

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

Code:

---

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 ?

256 char limit from query