Paul,

>Forgive me if I'm wrong but doesnt the ; mean continue on next line in Foxpro?

It does, but most people don't use it when building strings, because a string constant is limited to 255 bytes. Your string is right at 700 bytes.

You can use the next feature of TEXT

text to lcSQL noshow
select BvSurvey.Name as Survey, Hst_Path1 as ID_NUM, Hst_Path2 as ITS, Hst_Path3 as AppointmentID, 
Hst_Path6 as CallTimeSeconds, Hst_Path6 / 60 as CallTimeMinutes, BvPerson.Name as Interviewer,
BvAppointment.time as AppointmentTime, bvRole.Name as Role from dbo.bvhistory bvhistory
LEFT OUTER JOIN dbo.BvPerson BvPerson
ON bvHistory.PersonSID = BvPerson.SID 
LEFT OUTER JOIN dbo.BvAppointment BvAppointment
ON bvHistory.Hst_Path3 = BvAppointment.ID 
LEFT OUTER JOIN dbo.BvRole Bvrole 
ON bvHistory.RoleID = BvRole.RoleID 
LEFT OUTER JOIN Dbo.BvSurvey BvSurvey 
ON bvHistory.Hst_ObjID = BvSurvey.SID 
where bvHistory.EvtTp_ID = 204 and Hst_ObjID = 1576 and Hst_Path2 <> 16 order by Hst_Path2 
endtext

SQLExec( ... lcSQL... )

>Like
>
>Select * ;
>from customers ;
>where cu_name = upper('best customer') ;
>into cursor topcust