Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Character Removed

Status
Not open for further replies.
dbinfoweb

dbinfoweb

Technical User
Nov 20, 2001
59
US
I am just wondering if there is a way to remove the very last character in a field. Thanks in advance for any help.
 
Sort by date Sort by votes
I think you can use something like
Code: 
update TABLE set fl=(select SUBSTRING(fl,1,length(fl)-1) from TABLE where id=1) where id=1
[/color]

Hope this helps,
David.
 
Upvote 0 Downvote
Yes, it does. Thanks so much for your help, David.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

nyck
  • Locked
  • Question
character set help
Replies
0
Views
38
nyck
nyck
nyck
  • Locked
  • Question
Sybase Character Sets
Replies
1
Views
31
PDreyer
PDreyer
holdahl
  • Locked
  • Question
Character Set
Replies
0
Views
22
holdahl
holdahl
mevasquez
  • Locked
  • Question
Getting last month records
Replies
6
Views
185
SQLDenis
SQLDenis
sigmab
  • Locked
  • Question
scheduled task showing 0x2 as last result with sybase 9
Replies
0
Views
37
sigmab
sigmab

Part and Inventory Search

Sponsor

Back
Top