Re: trigger/procedure with single quote in string

Hi joc Try putting a backslash, like this: system("cprogram \\'This is the way the cookie crumbles\\' 200"); Actually doing what I suggested above doesn't need the \\. Maybe what you are doing is like this: LET cCommand = "cprogram \\'This is the way the cookie crumbles\\' 200" CALL cCommand Hope this helps Sujit Pal DBA, Computer Sciences Corp. > > I am writing a procedure that must write command line arguments > to a C program via a 'system' call. A space in the string has the result > of making the argv list have another member. putting single quotes around > the string could fix this problem, however, Informix SQL doesn't support > adding a single quote to a string as far as I can tell. Is there a way to > get a single quote in a string ? > tia. > > please reply to joc@disc.com > >