Select Number from a possible of 3 columns

[fergy1]

Hello-

I have an owners table where they have a list of 3 different companies in 3 columns (cnumber, cnumber2, cnumber3). I want my query to search on all 3 columns to find the match for the company they logged in under. How can I do this? So example would be:

 Select * from owners where cnumber, cnumber2 or cnumber3 = companyID

 

[DotNetGnat]

Select * from owners where cnumber = companyID OR cnumber2 = companyID OR cnumber3 = companyID

-DNG

 

[fergy1]

SQL allows for or statements like that on the where clause?

 

[DotNetGnat]

Yes...OR statements are allowed in the WHERE clause...

did you try it...are you getting in any errors...

-DNG

 

[fergy1]

It worked. I'm just surprised. I have not seen an OR statement used like that before. Thanks!

 

[DotNetGnat]

it is how the OR statements are generally used...

anyways...glad its working for you...

-DNG

 

[fergy1]

Yes, in asp or php not SQL at least that I have seen. If I had I would have used it...