Question About A Query

[dmaier]

I have a table that has team schedules and consists of the following fields:

HomeTeam, Opponent, Location, Date, Time

What I would like to do is to write a query that could query on a specific team, let's say Barracudas but some time the Barracudas are the HomeTeam and sometimes they are the away team(Opponent)

Is there a way to structure a query to be able to do that?

 

[Golom]

Something like

   Select * 
   From tbl
   Where HomeTeam = 'Barracudas' OR Opponent = 'Barracudas'