Click here to Skip to main content
15,942,093 members
Please Sign up or sign in to vote.
1.16/5 (4 votes)
See more:

I HAVE NOW ' RN 001 2023' AND NEED TO BE 'RN 001 2023'

Have 1 empty character on start

Hot to remove that?

I have some code but he remove all empty spaces

Need to remove first char because is empty

What I have tried:

update set work_name=REPLACE(work_name,  '  ', ' ')
Updated 18-Jan-23 1:22am

1 solution

Share this answer
Stylus STYLUS 18-Jan-23 2:33am    
With this method replace empty places with some another
I need to remove just first char which is empty
' RN 001 2023' AND NEED TO BE 'RN 001 2023'
OriginalGriff 18-Jan-23 4:05am    
Did you read what the function does?
Quote: "Remove leading and trailing spaces from a string"
Which means it does what exactly?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900