izenenigmai
Programmer
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 " </TD>". What I want to do is get rid of the " </TD>".
First of all, is there a way to perform a "delete right" or such function to delete the right 5 characters? If not, is there a function like a "delete instr" where I can put in " </TD>"?
First of all, is there a way to perform a "delete right" or such function to delete the right 5 characters? If not, is there a function like a "delete instr" where I can put in " </TD>"?