-
removing characters from a column
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
-
removing characters from a column (reply)
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
-
removing characters from a column (reply)
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
-
removing characters from a column (reply)
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
-
removing characters from a column (reply)
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
-
removing characters from a column (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|