I have an SQL query that I have been running from a VB app to a SQL server database. I would like to run this same query on the same data set in FoxPro free table. Can anyone tell me how to convert this query so that I can execute it from VB? The only thing I have changed here is the removal of the single quote characters.

SELECT case when svcarrtype in (" & 24 & "," & 22 & ") then replace(replace(svcarrfmt," & " " & "," & "" & ")," & "-" & "," & "" & ") when svcarrtype = " & 20 & " then RIGHT(LEFT(svcarrfmt, 16), 10) when svcarrtype in (" & 17 & ") then rtrim(ltrim(aggrfmt)) else svcarrfmt end as svcarrfmt From saxref WHERE svcarrtype NOT IN (" & 11 & "," & 13 & "," & 16 & "," & 15 & ")