can someone pls help me with this syntax.<br><br>BEGIN TRANSACTION tran_Individual_DuesCategory<br><br>UPDATE Individual<br> SET Individual.DuesCategoryID= DuesCategory.DuesCategoryID <br> <br><br>SELECT DuesCategoryID=DuesCategoryID <br> from DuesCategory <br>where DuesCategory.DuesCategoryName=Conversion.Con_L00200_Loc.catcde<br><br><br><br> DuesCategoryID= case Conversion.Con_L00200_Loc.catcde<br> when 'Active' then 'Per Diem'<br> when 'Probation' then 'No Dues.'<br> when 'Full Dues' then 'Full Dues.'<br> when 'Special 1/2 Dues' then '1/2 Dues.'<br> when ' ' then null<br>END