In sql server and in Azure the field that was causing the issue was a nvarchar(255), but the field coming back from salesforce was a numeric(10,0), so in my UDTT I change the field from nvarchar to numeric and that resolved my issue.
Thanks,.
KSS.