What does The SQL Standard say about this one? create table foo (a varchar, b int);
insert into foo (a, b) select null, null from bar; -- no problem insert into foo (a, b) select distinct null, null from bar; -- ERROR: column "b" is of type integer but expression is of type text -- HINT: You will need to rewrite or cast the expression. It seems that applying DISTINCT makes the NULL be of type TEXT... I just tried the exact same thing in Ms. SQL Server 2005 and it works with no errors. Looks like SQL Server makes the NULLs be INTs, but is probably better at doing the implicit conversion from INT. Any thoughts on what the "correct" behavior should be here? George ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
