Frank,

I can's speak for SQL-Server specifically, but the following works well for me:

lcSelect = [SELECT ..... ]
lcFrom   = [FROM .... ]
lcWhere  = [WHERE ..... ]
lcSQL = lcSelect + lcFrom + lcWhere 
SQLEXEC(nHandle, lcSQL)

>to all
>i am sending query stings to sql server to bring back cursors for my reports. when the string is 254 characters or less it runs fine but otherwise it bombs out. has anyone else had this problem, and/or is their a workaround for it
>tia
>frank