Hello, i have a column (STORE_ID) that contains only numeric characters and in some cases leading spaces. I want to trim leading zeros and spaces. Which is faster?
cast(cast(STORE_ID as integer) as Varchar(75))
trim (leading '0' from trim(leading from STORE_ID))
Great! Thanks! and that will left trim them in any order they appear, for any number of occurences? In other words it will remove ' 0', '0 ', ' 0000', ' 00000', etc?