jerepjohnson Posted June 24, 2009 Share Posted June 24, 2009 I would like to automatically/dynamically generate a new field from the social security field of our database that only contains the last five digits (and no hyphens). Is there an easy way to do this? Link to comment Share on other sites More sharing options...
mr_vodka Posted June 24, 2009 Share Posted June 24, 2009 Right ( Filter ( SSN; "0123456789" ); 5 ) Link to comment Share on other sites More sharing options...
jerepjohnson Posted June 30, 2009 Author Share Posted June 30, 2009 Thanks a lot! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5437 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