I am trying to concatenate two Text Field but error coming up: "The data types text and varchar are incompatible in the add operator." My Query Is:
select (CAST(User_OrdDtl as text) + ',' + CAST(User_OrdSDtl as text)) OrdDtl from Order_tb;
Can Anyone suggests how to concatenate two Text Field.
View Complete Post