Multiply WHERE's in SQL Statement

[SonicBoomAu]

Hi All,

 

Is it possible to have multiply WHERE statements in a SQL Statement?

 

This is the code I am currently working with:

 

               Dim str1 As String = "SwitchLoc"
               Dim str2 As String = "BladeNo"
               Dim str3 As String = "PortNo"

               Dim strNewSQLStatement As String
                       strNewSQLStatement = "SELECT " & strP2Custom & " From PermanentAssets WHERE " & _
                       str1 & " = '" & strSwitchLocValue & "' & " & _
                       str2 & " = '" & strBladeLocValue & "' & " & _
                       str3 & " = '" & strPortNoValue & "'"

 

strSwitchLocValue, strBladeLocValue, strPortNoValue are captured in another part of the program and are either set to * or a specifed value.

[Mister E]

Yes, SQL has the standard boolean operators such as AND and OR.

 

 

SELECT P.Name
FROM People P
WHERE (P.Age > 50 AND P.Rating < 80) OR P.Name='George'