>I need to be able to throw sql statements at either VFP or Sql Server and am toying with the idea of writing some sort of 'parser' routine which will handle syntax differences between the 2 eg INLIST for IN, .t./.f., dates etc etc
>
>Before I dive in, does anyone know of any third party software that could do this ?
Take a look on vfpsqlparser
http://www.geocities.com/SiliconValley/Hills/9119/sql_parser.htm