Hi,

You can try the following query :

select case isnumeric(YourFieldName) when 1 then YourFieldName else 0 end.

Hope that Helps 🙂