Replace Zero's in a integer with nothing and make it as Integer. - Cacher Snippet

3/26/2017 - 7:10 PM

Replace Zero's in a integer with nothing and make it as Integer.

Replace Zero's in a integer with nothing and make it as Integer.

SQL_Query_14.sql

--- Replace zero's in a integer with nothing, and make it as Integer

SELECT CAST(REPLACE(000050,0,'') AS INTEGER) AS 'Replace_Integer'

-- Linkedin Profile :https://www.linkedin.com/in/harshasannareddy/