How to trim leadings zeros from an SAP extract using SQL Server with Billy Thomas ALLJOY Data
In this video, you will learn two different ways to handle trimming leading zeros from a string value. The example shown in the video is from SAP but the solution can be applied to any dataset that has leading zeros.
@0:00 Introduction
@0:34 SAP Example
@1:49 Option 1 - LTRIM
@4:07 REPLACE
@5:29 Option 2
@6:25 PATINDEX
@8:55 SUBSTRING
@11:00 LTRIM Example on imported MARA table
#sqlserver #dataanalyst #dataquality #trimleadingzeros #ssms #alljoydata
Github Link:
https://github.com/billythomasalljoyd...