Trim last 2 Chars from a returned value

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
 
A

Allen Browne

Use Instr() to find the space, and Left() to accept just the part to the
left of that.
 
Top