No problem 'creating' the view, as the question asks. However, not sure the view necessarily 'works'. Potentially, the CASE statement WHEN clause may fail when converting varchar/nvarchar (returned by SUBSTRING) to int (returned by LEN)?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply