Insert statement help

any one can help what is wrong on this statement
insert into Test1 (FCODE, FNO) values (
SELECT 'A', Number
FROM dbo.Numbers
WHERE Number >=3
AND Number <= 5
and Number not in (select FNO from Test1 where FCODE = 'A')
)insert into Test1 (FCODE, FNO)
SELECT 'A', Number
FROM dbo.Numbers
WHERE Number >=3
AND Number <= 5
and Number not in (select FNO from Test1 where FCODE = 'A')|||Just AND operator for preventing from NULL's
SELECT 'A', Number
FROM dbo.Numbers
WHERE Number >=3
AND Number <= 5
and Number not in (select FNO from Test1 where FCODE = 'A' AND FNO IS
NOT NULL)
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:9765AB05-8B87-41D7-92C5-C971EB50C549@.microsoft.com...
> insert into Test1 (FCODE, FNO)
> SELECT 'A', Number
> FROM dbo.Numbers
> WHERE Number >=3
> AND Number <= 5
> and Number not in (select FNO from Test1 where FCODE = 'A')
>
>