Skip to Content
0
Former Member
Mar 04, 2009 at 02:36 AM

Formatted Search on TaxCode Ship To addess

67 Views

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