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.update table
set COLUMN = LTRIM(NAME, SUBSTR(COLUMN, 0, 10));|||UPDATE conitemdescrip
SET descrip= LTRIM(descrip,SUBSTRING(descrip,0,10));
Msg 174, level 15 State 1
the function 'ltrim' requires 1 argument
Suggestions?|||You are using MS SQL Server 2000.
update table
set column = Right(column, Len(column) - 1)
- From Visual Basic|||No, I am using
SQL 6.5...sql
No comments:
Post a Comment