I am using the modify data command of the DBC and then select add remote view.

Where do I put the CAST(TableA.Vendor_number) as int

I thought I would try to change it in the JOIN tab by going to the bottom of the fields and building an expression.

I use cast( Original_ap_invoices.VENDOR_NUMBER) as int
and then hit verify and it says expression OK.

When I try to save the view it says incorrect syntax near expression ‘CAST’, expected ‘AS’

If I use cast( Original_ap_invoices.VENDOR_NUMBER as int)
then it tells me missing )


I am getting CLOSE, but close only counts in horse shoes, hand grenades and atomic bombs. With the SQL syntax it is 100% or ZERO.