Hi all I asked about this quite some time ago and somebody suggested http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~WIN_COM_API. This is very useful but this only includes string functions. Any ideas where I might find something similar for date and numeric functions? Many thanks Paul Newton