By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TestTable (Id INT IDENTITY(1,1) NOT NULL, SampCol INT);
INSERT INTO TestTable (SampCol) VALUES
(1), (4), (NULL), (6), (8);
5 rows affected
SELECT Id, COALESCE(CAST(SampCol AS VARCHAR (10)), '') AS SampCol
FROM TestTable
| Id | SampCol |
|---|---|
| 1 | 1 |
| 2 | 4 |
| 3 | |
| 4 | 6 |
| 5 | 8 |