>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


DOH! You got me by 6 seconds. ;)