The correct syntax is

SELECT * FROM MyTable where  PK_FLD BETWEEN nLow AND nHigh

>
>What do you think of comparison in speed in SQL Select WHERE clause between using BETWEEN() or Greater than and Less than ?
>
>For example,
>
>

>   SELECT * FROM MyTable where PK_FLD < nHigh and PK_FLD > nLow
>
>*-- VS
>
>  SELECT * FROM MyTable where BETWEEN( PK_FLD, nLow, nHigh)
>
>

>
>And I am talking about using the syntax for both VFP database as well as SQL server.
>
>TIA.