Click here to Skip to main content
15,900,108 members

Comments by Skipton Corp (Top 5 by date)

Skipton Corp 17-Sep-18 12:15pm View    
OriginalGriff,
Would you say the following would work same as yours?

SELECT [Name]
,CASE
WHEN [Code] IS NULL
THEN ''
ELSE [Code]
END AS [Value]

FROM MyTable
Skipton Corp 14-Aug-18 6:55am View    
Thank you for the solution.
Skipton Corp 9-Aug-18 8:01am View    
Thank you OriginalGriff for the clarity.
Skipton Corp 9-Aug-18 3:58am View    
Thank you for the solution.
Skipton Corp 9-Aug-18 3:58am View    
Deleted
Thank you for the solution.