Hi Experts,
I have a Customer who wants a Formatted Search Linked to the Ship To address. This Formatted Search must populate TaxCode 'TST' when the State in the 'Ship To' address are Texas. When it is anything other than Texas, it must populate 'EX'.
The following is what I started, but it does not just populate the 'EX' or 'TST'. (It brings up a table....)
SELECT CASE WHEN $[CRD1.State] <> 'TX' THEN 'EX' ELSE 'TST' END
FROM CRD1
Any help would be greatly appreciated.
Thanks,
Marli