Hello,


is there a way to convert a string to a number in a where clause without
error?
for example
select * fromd data where cast(sn as integer) > 1000;


i tried to replace it with and some others...
select * from daten where (case when sn similar to '[0-9]+' then cast
(sn as integer) else null end ) > 0;         -> still error on first non
number string.