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.
| Author |
Topic |
|
dasql
Starting Member
2 Posts |
 Posted - 2005-07-20 : 17:31:42
|
| Hello all, I am looking to search in a progressive manner. For example:Select ID, Name, State, Country From SearchDatabaseWhere (ID = 101 AND Name = 'Jay' AND State = 'CA' AND Country = 'USA') OR(Name = 'Jay' AND State = 'CA' AND Country = 'USA') OR(State = 'CA' AND Country = 'USA') OR(Country = 'USA')Now I have record with will match the first condition right off the bat but then I dont want to go to the other 3 conditions if I find a match for the one above. So its progressive. If I dont find any for first then goto 2nd then if nothing for 2nd then 3rd else stop at 2nd.Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-20 : 19:09:45
|
| Don't cross-post....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52669 |
 |
|
|
|
|
|
SQL Query to Search