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 SkipVought 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
0
0
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
  • Question
SSMS question 1
Replies
4
Views
475
Sana Shazadi
S
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
96
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
Simple SQL Pivot
Replies
9
Views
103
Chris Miller
Chris Miller
RazorEddie
  • Locked
  • Question
Simple query gone wrong
Replies
10
Views
75
RazorEddie
RazorEddie
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
49
ahmedsa2018
ahmedsa2018

Part and Inventory Search

Sponsor

Back
Top