You need to construct a string which represents the SQL query like this:

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

*- Then execute the sql statement using macro substitution
&cSql

Or to construct a SQL command without Macro Substitution you can try this:

cCod = '1'
cBranch = 'Brn1'

IF Thisform.Check1.Value = 1
   Select ItmCod, ItmDes From ItmMast Where ItmMast.ItemCod = cCod
Else
   Select ItmCod, ItmDes From ItmMast Where ItmMast.ItemBrn = cBranch
Endif

Glenn


>

>Hi Experts,
>
>I have an sql Query statement, i want retrive data based on condition like
>
>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.
>
>Please i need somebody's kind help in the regard
>
>Thanks in advance
>
>Regards
>
>Abdulla