How To Add Explicit Null For Missing Data While Retrieval

Hi there,
I was wondering if someone could propose a solution for the following scenario:

TimeID column would have values from 1 to 6 and rows will be inserted only for those timeIDs where we have Data value as well. While retrieving data we would like to have all timeID range returned with explicitly specifying NULL for missing Data column. Please see below to better understand the situation.


create table test

(

TimeID INT,

Data INT

)


INSERT INTO test VALUES(1, 100)

INSERT INTO test VALUES(2, 180)

INSERT INTO test VALUES(4, 550)

INSERT INTO test VALUES(6, 120)


select * from test

1 100

2 180

4 550

6 120


Desired resultset

1 100

2 180

3 NULL

4 550

5 NULL

6 120

...