Concatonating PARTS of fields

[parima]

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

[mr_vodka]

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)

[parima]

You are absolutely my hero!

-parima