compact where clause
From: ben h (why_mail_me_at_all.com)
Date: 06/24/04
- Next message: JP: "Linked Server to Access DB (pllleeeaasseee help) :)"
- Previous message: Alan: "How to query two SQL Server instances"
- Next in thread: David Portas: "Re: compact where clause"
- Reply: David Portas: "Re: compact where clause"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 16:14:25 +1000
Don't ask why i need this, (well i'll tell you why: html <select> element
limitations) here is my DDL:
create table actions (
ownerID nvarchar
originatorID nvarchar
actioneeID nvarchar
... other fields....
)
i need to filter a view on one of 4 selections in html <select> like so:
where
1 ownerID='user'
2 originatorID='user'
3 actioneeID='user'
4 [one of any of the above] = 'user'
selection 4 is the tricky one for me: is there another way that i can create
the last choice other than:
WHERE (ownerID='user' OR originatorID='user' OR actioneeID='user')
?
Ben
- Next message: JP: "Linked Server to Access DB (pllleeeaasseee help) :)"
- Previous message: Alan: "How to query two SQL Server instances"
- Next in thread: David Portas: "Re: compact where clause"
- Reply: David Portas: "Re: compact where clause"
- Messages sorted by: [ date ] [ thread ]