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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep Last character

Status
Not open for further replies.
jw5107

jw5107

Technical User
Jan 20, 2004
294
US
I am bulding a query and I need to perform a trim of some sort that keeps the last character in the value.
No matter how long the string is - I need the last charter as the result.

Any suggestions or examples???

Thanks,
jw
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

supportsvc
  • Locked
  • Question
Previous Quarter Sum and Last Quarter Sum in 1st Q the Following Year 1
Replies
12
Views
552
supportsvc
supportsvc
Lavenderchan
  • Locked
  • Question
Return Records for last 5 years 1
Replies
1
Views
198
dhookom
dhookom
Bennie47250
  • Locked
  • Question
Replace only if the last character of a field is a specific character 1
Replies
7
Views
617
Andrzejek
Andrzejek
misuser2k7
  • Locked
  • Question
Delete query to delete every last remaing record in group of records 1
Replies
8
Views
273
dhookom
dhookom
Moss100
  • Locked
  • Question
Return Characters to left of final dash in an address 2
Replies
4
Views
278
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top