Goran Bibic

Goran Bibic

  • 480
  • 2.9k
  • 200.7k

Remove first char in field MSSQL

Jan 18 2023 6:51 AM

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

I try this but taht remove all empty spaces

update dbo.work set work_name=REPLACE(work_name,  '  ', ' ')

 


Answers (5)