Well, someone on the west-wind.com forums gave this code to help convert Sql statement from VFP to Sql Server format. ( full link here: http://www.west-wind.com/wwThreads/default.asp?Thread=2PP17MHZ0&MsgId=2PR1FFRHX )

I have not tested it, but I am just posting it here in case it helps anyone else:

West-Wind user Jukka Salminen posted this:

I can give an example of one solution. I have added a method (fixsql) to my custom wwBusiness subclass that converts from Fox- to SQL-syntax. The current version looks like this:

LPARAMETERS lcSelect
* _DBPrefix = 'dbo.'
If This.nDatamode = 0
  If Vartype(lcSelect) = 'C'
    lcSelect = Strtran(lcSelect, '_DBPrefix.', "")
    lcSelect = Strtran(lcSelect, CRLF,' ')
    RETURN lcSelect
  Endif
Else
  If Vartype(lcSelect) = 'C'
    lcSelect = Strtran(lcSelect, CRLF,'|')
    lcSelect = Strtran(lcSelect, '_DBPrefix', Server.oConfig.cDatabasePrefix)
    lcSelect = Strtran(lcSelect, '==', "=")
    lcSelect = Strtran(lcSelect, 'SUBSTR(', "SUBSTRING(")
    oRegExp.Pattern="isnull\(([^( ]*)\)"
    lcSelect = oRegExp.Replace(lcSelect, "$1 is null ")
    oRegExp.Pattern="not\s*empty\(([^( ]*)\)"
    lcSelect = oRegExp.Replace(lcSelect, "$1 <> '' ")
    oRegExp.Pattern="iif\(([^,]*),([^,]*),([^\)]*)\)"
    lcSelect = oRegExp.Replace(lcSelect, " case when $1 then $2 else $3 end ")
    lcSelect = Strtran(lcSelect, " currency", " money")
*    oRegExp.Pattern="as\s*currency"
*    lcSelect = oRegExp.Replace(lcSelect, "as money")
    lcSelect = Strtran(lcSelect,'|', CRLF)
  Endif
Endif
RETURN lcSelect

Then I call this method ex. in query() like this:

Lparameters lcSelect, lcCursor, lnResultmode
lcSelect = this.fixsql(lcSelect)
Return DoDefault(lcSelect, lcCursor, lnResultmode)