Hi Philip,

When I used to have this type of problem. Someone here on the UT one told me to break the string into smaller parts. Then add them all together.

csqlstring1 = "SELECT ....."

csqlstring2 = "FROM ......."

csqlstring3 = "WHERE ......"

csqlstring4 = "GROUP BY ..."

csqlstring5 = "ORDER BY ..."

csqlstatement = csqlstring1 + csqlstring2 + csqlstring3 + csqlstring4 + csqlstring5

nconhandle = sqlexec(nhandle, csqlstatement, 'some_cursor')

I have found this works great for all my SQL work. Insert, Delete, Update

HTH
Mike