Hi
I have below FMS. I want if Vendor Code is '123' then Udf field should be blank else it should get GstNo
select distinct GSTRegnNo from crd1 where crd1.CardCode=$[opch.cardcode]
and crd1.address=$[opch.shiptocode]
case
when $[opch.cardcode] = '29' then U_GstNo = ''
Thanks