Be the star of a SQL Prompt case study. Learn more.

CAST function not being properly formatted like other functions, ie. ISNULL

            '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


Sign In or Register to comment.