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!

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

Remove first three chars in text field. How?

Status
Not open for further replies.

BasilFawlty001

IS-IT--Management
Apr 26, 2002
29
CA
I want to remove the first three characters in a text field but can't find any formulas to do that. Help. Thanks.
 
try using someting that does this

field - left(field,3)

the 3 will take the 3 left characters off of it.

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned
 
Actually you want Right({field},length({field})-3) to get all except the first 3 characters Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top