remove leading spaces

[timscronin]

I have some data where the user hit a carriage return at the beginning where data looks like

T1 D X365D

I need it to look like

T1 D X365D

How can I remove just the leading char(13) spaces?

 

[bdreed35]

Give this a try:

LTRIM(REPLACE(field1, char(13),''))

~Brian

 

[jby1]

use the LTRIM function

 

[timscronin]

the ltrim with the replace only removes the first space, I need all leading spaces replaced.

 

[dickiebird]

Try just replace ?

REPLACE(field1, char(13),'')


Dickie Bird (-)))

 

[supermama]

you just need to use the LTRIM command.
Something like this

LTRIM(@varname)

This eliminates all leading spaces.

 

[dickiebird]

It's not spaces. though, it's ascii 13

Dickie Bird (-)))

 

[timscronin]

the REPLACE(field1, char(13),'') removes only the first
space