fileman922 Posted November 18, 2016 Share Posted November 18, 2016 hello, i would like to know how to take just the last 2 characters of a field example: if the field is "342399" i would like the field "99" or field is 3467564354677 i would like the field "77" i know how to delete characters but i dont know how to leave the last 2 characters. please let me know thank you Link to comment Share on other sites More sharing options...
comment Posted November 18, 2016 Share Posted November 18, 2016 Have a look at the Right() function. Link to comment Share on other sites More sharing options...
fileman922 Posted November 19, 2016 Author Share Posted November 19, 2016 Thank you ! it works Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2716 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now