compact where clause

From: ben h (why_mail_me_at_all.com)
Date: 06/24/04


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