Remove first char in field MSSQL

Goran Bibic

3y777C#

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,  '  ', ' ')

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar3y ago
Accepted answer
You can use TRIM() function of SQL,

For Start Only LTRIM(work_name)

For end Only LTRIM(work_name)

For start and End Both then TRIM(work_name)
```
For Start Only 
update dbo.work set work_name = LTRIM(work_name)

For Right Only
update dbo.work set work_name = RTIM(work_name)

Both Side
update dbo.work set work_name = TRIM(work_name)
```
Naimish Makwana3y ago
Hello Goran,

To remove first empty char in field. You can do as below.
```
update dbo.work set work_name= STUFF(work_name,1,1,'')
```
Sample of remove first blank space from value.
```
SELECT STUFF(' RN 001 2023',1,1,'') AS Result
```
Thanks

Naimish Makwana
Vishal Joshi3y ago
Hello

Try SQL Server TRIM() Function

Please try the below query to remove space.
```
update dbo.work set work_name= TRIM(work_name)
```
Thanks
Goran Bibic3y ago
I need to remove first emty char in field

Instead ' RN 001 2023' AND NEED TO BE 'RN 001 2023'

Hello Goran,

Please try the below solution.

update dbo.work set work_name=RIGHT(work_name, LEN(work_name) - 1)

Sample of remove space from value.

SELECT RIGHT(' RN 001 2023', LEN(' RN 001 2023') - 1) AS Result

Thanks