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

Instr Delete? Right Delete?

Status
Not open for further replies.

izenenigmai

Programmer
Aug 10, 2001
2
US
I have a field in a linked table which I would like to trim. The table data changes constantly, and I'll need to write an update query to get the data in the field that I need. Basically the field is a 15-20 character number, followed by &quot; </TD>&quot;. What I want to do is get rid of the &quot; </TD>&quot;.

First of all, is there a way to perform a &quot;delete right&quot; or such function to delete the right 5 characters? If not, is there a function like a &quot;delete instr&quot; where I can put in &quot; </TD>&quot;?
 
Try this
Code:
Left(fieldName, len(fieldName)-5)

Replace fieldName with the name of your string or field. The hardest questions always have the easiest answers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top