Trim last 2 Chars from a returned value

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

Anthony Viscomi

I am having a "brain freeze"...I have a query that returns a value that
looks like this:

113883001 5P

There is always a "space" before the 5P; my question is how can I just
return the value after the last character, in this case the last character
would be the 1.

Thanks,
Anthony
 
Use Instr() to find the space, and Left() to accept just the part to the
left of that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return all after specific character. left, right, mid??? 5
TRIM function isn't working in my query 3
return specific character read from right to left 0
Access Access anti-trim?? 0
Trim Query 1
Input and return multiple values from a query 2
TRIM FUNCTION in QUERY 1
Trim Field 1

Back
Top