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.






Reply via email to