>No, there is no a direct way to do this (at least I don't know one).

remembering that that i've asked that question before {imbaresed smile}, i found the answer from Sergey back then ID #875196 .

so i have updated my querry to this functionality. but i still would like to have it in a memo field. i think (not too long ago) i saw a solution to add a memo field to a sql command from Sergey, but i don't remember which message it is. as i remember it was a 2 step solution.

anyone remembers that thread?

Thanks for all your help!