Following is the value of the memo field. I need to execute this but when i try to execute this after taking it into a variable i got an error message. I have executed this script after copying it into the prg. Please give me some another solution if available. Thanks in advance.


SELECT X.cid, ;
X.cprojno AS XProjectNo, ;
X.cunitnum, ;
X.cseqno, ;
X.ctentno AS XSSNo, ;
X.clstname AS XLastName, ;
X.cfstname AS XFirstName, ;
X.captno AS XAptNo, ;
X.caddline1, ;
X.caddline2, ;
X.ccity, ;
X.ccounty, ;
X.ccontno, ;
X.cmailadd, ;
X.cmailaptno, ;
X.cmailcity, ;
X.cmailstate, ;
X.cmailzip, ;
X.cphone, ;
X.cprogtype, ;
X.clrstatus, ;
X.cs8status, ;
X.dappln, ;
X.deviction, ;
X.dlastexam, ;
X.dmovein, ;
X.dmoveout, ;
X.dreexam, ;
X.drenteff, ;
X.cmailadd2, ;
X.mxml, ;
Y.csocseqno, ;
Y.calienid AS YAlienId, ;
Y.ccitizstat AS YCitizenStatus, ;
Y.cethnicity, ;
Y.cfstname, ;
Y.clstname, ;
Y.cmidinit, ;
Y.cminority, ;
Y.cnation, ;
Y.crelation AS YRelation, ;
Y.csex, ;
Y.cstate, ;
Y.ddtbirth AS YDateofBirth, ;
Y.ldisabled, ;
Y.lelderly, ;
Y.lhandicap AS YHandicap, ;
Y.nassetamt, ;
Y.nassetincc, ;
Y.nbenamt, ;
Y.nccareamt, ;
Y.nearnasst, ;
Y.nhcassist, ;
Y.nincded, ;
Y.nincexcl, ;
Y.nmcareamt, ;
Y.notheramt, ;
Y.ntotexp, ;
Y.ntotinc, ;
Y.ntotwages, ;
Y.nwlfamt, ;
Y.coccupdesc, ;
Y.cablework, ;
Y.nschoolid ;
FROM x, y Where Y.cXId = X.cid


Deepak.