HELP!!! Result too long

[Mcp]

Consider the following...

Select Distinct id, A & “ “ & B as Res
From tblMain


A is type text
B is type memo

Result cuts cut off at 255 Characters….

How can I get the entire result – More than 255 characters??

Thanks

 

[Mcp]

Anyone know???

 

[KenHigg]

The only thing I can think of is to append this into a temp table where the fld is set to a memo...

???
kh

 

[Mcp]

I have found the problem....

Apparenty you cannot use Distinct on memo.....