Hi all members.
I need to ask for the following code. I need to convert the variable into a string.
"Select Distinct convert (int ,A.CustomerCategory) as AccountReceivableCategoryID, convert (varchar(40), B.Text) as AccountReceivableCategoryNameE
from Inkunde A , inpara B
where A.CustomerCategory= B.SearchItem
and B.Language1 = 'EN'
and B.ParameterName = 'CATEGORY'
and A.CustomerCategory = (DT_STR,200,1252) "+ @[User::CategoryID] +"
Order By A.CustomerCategory"
Kindly any member let me know, How to correctly use the Type Cast fucntion in variables
Thanks and Best Regards,
View Complete Post