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!

Replace first 3 characters? 1

Status
Not open for further replies.
bobbyr

bobbyr

Programmer
Nov 30, 2000
66
US
I have a varchar string and I need to remove the first 3 characters, no matter what they are.

Example:

*A4This is my string

I need to remove the *A4. Any suggestions?

Thanks,
Bobby R
 
Sort by date Sort by votes
Mid(String,4) should do the trick Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
134
Kennymc
Kennymc
auylox
  • Locked
  • Question
Unable to display certain punctuation characters from a memo field
Replies
4
Views
241
IanWaterman
IanWaterman
Marco Poblete
  • Locked
  • Question
how to save the value of column from the first record to a global variable and use it later?
Replies
18
Views
1K
Marco Poblete
Marco Poblete
bestmakis
  • Locked
  • Question
Print second report after first report finish
Replies
10
Views
399
bestmakis
bestmakis
kate8
  • Locked
  • Question
How to do the first date of the year in command
Replies
2
Views
234
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top