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.
 
Back
Top