CAST function not being properly formatted like other functions, ie. ISNULL
dpbouchard_aetna
Posts: 2 New member
in SQL Prompt
'FeedUpdate' + CAST(d.DocumentTypeId AS VARCHAR(40)) AS ConfigKey
, CAST(a.CYContractYear AS VARCHAR(4)) + ' ' + d.DocumentTypeName AS ConfigValue
, CAST(b.FeedId AS VARCHAR(2000)) AS Description
should have spaces around the parentheses but it doesn't
Tagged:
Answers
We have recreated this on our end and are escalating it to the dev team to look into.
Best,
Dustin
We wanted to follow up on this one, our dev team has notified us they have placed this on their schedule to take a deeper look.
Best,
Dustin
I wanted to follow up with you on this bug, this should be resolved in the latest release of SQL Prompt.
Best,
Dustin