removing characters from a column

[lisa]

Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa

[vesna]

use

substring () function


------------
lisa at 9/19/01 10:57:32 AM


Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa

[lisa]

Can you please elaborate?
Thanks.


------------
vesna at 9/19/01 11:21:43 AM



use

substring () function


------------
lisa at 9/19/01 10:57:32 AM


Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa

this should work

UPDATE Table
SET Column = SUBSTRING(column,LEN(column) -2 , 3)



------------
lisa at 9/19/01 10:57:32 AM


Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa

Sorry !!!!!

UPDATE Table
SET Column = SUBSTRING(column,1,LEN(column) -3)


------------
at 9/19/01 11:47:39 AM

this should work

UPDATE Table
SET Column = SUBSTRING(column,LEN(column) -2 , 3)



------------
lisa at 9/19/01 10:57:32 AM


Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa

[lisa]

Thank you very much!!!
Lisa


------------
at 9/19/01 11:54:47 AM

Sorry !!!!!

UPDATE Table
SET Column = SUBSTRING(column,1,LEN(column) -3)


------------
at 9/19/01 11:47:39 AM

this should work

UPDATE Table
SET Column = SUBSTRING(column,LEN(column) -2 , 3)



------------
lisa at 9/19/01 10:57:32 AM


Can someone please suggest a function to remove the last 3 characters from a column? I was thinking of the LEN function, but I am unsure of the syntax.

Thanks!
Lisa