If you really want the contents of the memo field in a string just use:
select padr(<memofield>,254) as <fieldname>
your memo2string function is not necessary and padr() doesn't care if the memo field is empty
the down side is that you can only use up to 254 characters since you are creating a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.