I'm dealing with a SQL question that peruses from a SQLServer information base to create a concentrate document. One of the prerequisites to eliminate the main zeroes from a specific field, which is a basic VARCHAR(10) field. In this way, for instance, on the off chance that the field contains '00001A', the SELECT assertion needs to return the information as '1A'.
Is there a way in SQL to handily eliminate the main zeroes along these lines? I realize there is a RTRIM capability, yet this appears just to eliminate spaces.