Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Between and more info

Author  Topic 

Einar
Starting Member

2 Posts

Posted - 2007-12-18 : 11:10:11
Hi, I hope someone can help me with this.

I want to get a query from a database

from between '3' AND '5' (NO PROBLEM)

but I want to add that I want info from 7 and up

how would I write that ? (if I do it in seperate lines the query returns nothing) which is not true.

Thank you.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 11:13:28
Try this:-
WHERE field BETWEEN 3 AND 5
OR field>=7
Go to Top of Page
   

- Advertisement -