Now here's the weird thing. When I run this (on SQL Server 2005):Create Table #Test(col varchar(10))

go

Insert into #Test

Select cast(1 as varchar(10))

union Select 2

union Select 3

union Select 4

union Select 5

union Select 6

union Select 7

UNION Select 'A'

union Select 'B'

union Select 'C'

union Select 'D'

Select Col

From (Select Col

From #Test

Where Isnumeric(Col)=1) X

Where Col Between 1 and 6

go

Drop table #Test I get the exact same error!?!