Comments by Member 14751855 (Top 1 by date)

Member 14751855 21-Feb-20 16:12pm View

IIf([group_code]="NA","Not Discountable",
"Discountable - "+[GROUP_DESCRIPTION])
AS [SOC_DISCOUNT_GROUP Desc],

In Sql Query--
Case
when group_code]="NA"
then "Not Discountable"
Else "Discountable - "+[GROUP_DESCRIPTION]
end
[SOC_DISCOUNT_GROUP Desc]
Is this correct? I have confusion only at Else part...where to add +[GROUP_DESCRIPTION]? what plus sign indicate?

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid