What about the "and" clause?
>>>Hi
>>>
>>>I've wriiten a Foxpro proceedure in VFP9 that allows the user to build up a command using different selected search criteria, this then creates an SQL type command that extracts data from a massic Postcode table.
>>>
>>>E.g.
>>>
>>>mfullcond="SUBS(DMOS,4,1)$AB and left(f17,1)='0' "
>>>SELECT * from q.dbf WHERE &mfullcond INTO TABLE results
>>>
>>>The customer is now interested in transfering the data into an SQL 2008 server, are the same/similar commands available with real SQL 2008.
>>>
>>>Is it possible to do contained within in SQL, and can you do left in SQL 2008?
>>>
>>>Any help extremley appreciated
>>>
>>>Rob
>>
>>
>>Robin,
>>
>>This may give you an idea
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP>
>Many thanks Gregory
Rob