Hi,

Suppose if your query will be like this ie (Col='A') instead of (Col=1)

Select Col

From (Select Col

From Test

Where Isnumeric(Col)='A') X

Where Col Between 1 and 6

You can get the error that is syntax error converting the varchar value 'A' to a column of data type int.