Remove first char in field mssql

See more:

SQL

I MAKE MISTAKE IN CODE

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 dbo.work set work_name=REPLACE(work_name,  '  ', ' ')