Subject then varchar to Integer is numeric else 0
Author Ismael L. Donis GarcĂ­a
I have in SQL200 the following:
(case when not isnumeric(ventas.entidad) = 0 then convert(integer, ventas.entidad) else 0 end) as entidad

And I try to convert FB2.1.4
(case when not r.entidad is numeric then 0 else cast(r.entidad as integer)) as entidad

But give me an error, as the field could convert varchar to integer?

Best Regards
|| ISMAEL ||

[Non-text portions of this message have been removed]