Thx very much!

But after some search in google, I found that isnumeric() return true for data like "- 1", which can't be convert to numeric data.

Instead, now I convert and...

First, thx for your help!

Do you mean this:

SELECT Expr1

FROM (SELECT [data-id], CAST(data AS int) AS Expr1

FROM Data

WHERE ISNUMERIC(data) = 1

AND data IS NOT NULL) DERIVEDTBL

WHERE (Expr1 > 5)

But sorry, the...