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

simple question remove char 1

Status
Not open for further replies.
Newbi1

Newbi1

Programmer
Apr 4, 2005
64
US
I am having a brainf*&*t today.

Simple string query to remove the first character off of the string. They could be various lengths so just need to cut off the leading char.
 
Sort by date Sort by votes
Select Right(<col>, Len(LTrim(RTrim(<col>))) - 1 ) from <table>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
1K
Sana Shazadi
S
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
677
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
Simple SQL Pivot
Replies
9
Views
547
Chris Miller
Chris Miller
RazorEddie
  • Locked
  • Question
Simple query gone wrong
Replies
10
Views
506
RazorEddie
RazorEddie
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
249
ahmedsa2018
ahmedsa2018

Part and Inventory Search

Sponsor

Back
Top