cSelect = [SELECT * FROM MyTable ] cWhere = [WHERE SomeField = “Some character value” ] + ; [AND SomeOtherCondition = .T. ] cOrderBy = [ORDER BY Field1, Field2, Field3 ] cSQLCommandString = cSelect + cWhere + cOrderBy lWasISuccessful = SQLEXEC(lnHandle, cSQLCommandString, "ResultCursor")