April 8, 2015

Effective use of COALESCE in SQL Server

DECLARE @Table TABLE
(
Phone1 VARCHAR(10),
Phone2 VARCHAR(10),
Phone3 VARCHAR(10)
)


INSERT INTO @Table
SELECT '998888','385832','83853385' UNION ALL
SELECT Null,Null,'83853385' UNION ALL
SELECT Null,'84282484','83853385'

SELECT COALESCE(Phone1,Phone2,Phone3) FROM @Table

No comments:

Post a Comment