Q: During the verification process, you find that you missed a few leading spaces during data cleaning. What function can you use to eliminate these spaces?
or
Q: You discover that you overlooked a few leading spaces while cleaning the data during the verification procedure. How can you remove these gaps using a function?
- TRIM
- TIDY
- CUT
- CROP
Explanation: During the process of data cleaning, you may make use of the LTRIM function in SQL to remove any leading spaces. This method will remove any leading spaces (or characters that you specify) from a string. This will ensure that any unnecessary spaces at the start of the data are cut.
