Joined: 15 Nov 2007
Location: United States
Online Status: Offline
Posts: 46
Posted: 23 Feb 2017 at 4:23am
Hi Kevlray,
I have a need to do something which I believe is similar to what you've created here. I have a variable sized field which ends with an account number. I need to report on all records where the account number begins with an '8', which will always be in the 10th position from the right. Is there a way, starting from the end of the field, to check the 10th position to see if it is an '8'? I've been playing around with the right() function but not getting the results I need.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum