Delete a Substring

reb1577 · #1 (**permalink**) 12-30-03, 12:18

Good morning,

I need to delete the first ten characters from a field, I don't know how to write this query to allow me to do so.

r123456 · #2 (**permalink**) 12-30-03, 12:27

update table
set COLUMN = LTRIM(NAME, SUBSTR(COLUMN, 0, 10));

reb1577 · #3 (**permalink**) 12-30-03, 12:34

UPDATE conitemdescrip
SET descrip= LTRIM(descrip,SUBSTRING(descrip,0,10));

Msg 174, level 15 State 1
the function 'ltrim' requires 1 argument

Suggestions?

r123456 · #4 (**permalink**) 12-30-03, 12:43

You are using MS SQL Server 2000.

update table
set column = Right(column, Len(column) - 1)

- From Visual Basic

reb1577 · #5 (**permalink**) 12-30-03, 12:57

No, I am using
SQL 6.5...

Internet Services

Web Development

Digital Marketing

Consumer Tech