Skip to Content
-1
J S
Aug 31, 2020 at 04:37 AM

Incorrect syntax near the keyword when

49 Views Last edit Aug 31, 2020 at 04:55 AM 2 rev

Hi

Select 
(case 
when substring($[RDR1.U_Code], 1,5) = 'U_CMax then Select 'U_Max' from Oitm  where OITM.ItemCode =  $[RDR1.ITEMCODE]
when substring($[RDR1.U_Code], 1,5) = 'U_CApple then Select 'U_Apple' from Oitm  where OITM.ItemCode =  $[RDR1.ITEMCODE]
End)

Thanks