>Hi All:
> What is the equivalent of between() in sql?
>Thanks
>MA

Mahmood,

In MSSQL 7, an example:

Select *
From MyTable
Where MyField Between 1 And 10

The above will return all records where MyField is between (and including) 1 and 10.

Hope this helps.

Don