good explanation John....
the error is coming due to incompatibility of datatypes in UNION....
but if we do like this -
DECLARE @id varchar(10)
set @id = 'A'
select isnumeric(@id)
It always gives 1
why?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/