Newbies parima Posted February 4, 2005 Newbies Share Posted February 4, 2005 I have an identifier that I want to generated based on other information entered. It seems redundant and chancy to make the user create the identifier when they have to enter in the other info. Example: FirstName: Mary LastName: Watson SSN: 123-45-6789 resulting identifyer: WM6789 I know how to concatonate, I just don't know how to extract precise data from a field. Help please? -parima Link to comment Share on other sites More sharing options...
mr_vodka Posted February 4, 2005 Share Posted February 4, 2005 You can get precise data from a field by the Left, Middle, and Right functions. cConcatKey = Left (LastName;1) & Left (FirstName;1) & Right(SSN;4) Link to comment Share on other sites More sharing options...
Newbies parima Posted February 4, 2005 Author Newbies Share Posted February 4, 2005 You are absolutely my hero! -parima Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7021 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