I have 2 tables [both are identical in column name and datatype] with memo field, when selecte values from both the table with union query I face a problem of 1st 255 chars. of the memo field. How to get the full values of the column?

Rgds,

Vikas