Out Put is : 0

Warning message wasn't showing in any of the versions (2000 and 2005)

Yes I do agree. But Answer is "NO". Why they have given "Yes" and explanation 'No'. Its totally contradiction.

Thanx. That is the spirit. I think this topic will ends here.

I have opened seven tabs and runned the same query in SQL2000

" Select Col From (Select Col From Test Where Isnumeric(Col)=1) X Where Col Between 1 and 6 "

Still...

So given question is wrong , compare to your queries:

If you run the below queries the ans is: 1,2,3,4,5, and 6.

If I am correct.....

Create Table Test(col varchar(10))GO

Insert into Test Select...

Can you plz explain, why the error comming ?

Hi,

When i running the below query,

Select Col From (Select Col From Test Where Isnumeric(Col)=1) X Where Col Between 1 and 6

Output is: 1,2,3,4,5 and 6

Still my answer is...