cCod = '1' cBranch = 'Brn1' IF Thisform.Check1.Value = 1 cCondition = 'ItmMast.ItemCod = ?cCod' Else cCondition = 'ItmMast.ItemBrn = ?cBranch' Endif cSql = "Select ItmCod, ItmDes From ItmMast Where " + cCondition SQLExec(nConn, cSQL )>
>cCod = '1' >cBranch = 'Brn1' > >IF Thisform.Check1.Value = 1 > cCondition = 'ItmMast.ItemCod = cCod' >Else > cCondition = 'ItmMast.ItemBrn = cBranch' >Endif > >'Select ItmCod, ItmDes From ItmMast Where cCondition'>How i will i convert this to an Sql Server statement.