Query - Selecting specific characters

[Quan9r]

I would like to run a query the pulls the first letter of a persons last name AND pull just the last four characters of their Social Security Number - Is there a way to limit the selection of characters in a text field?

Is there a way to sort by the last two digits in a persons SSN?

I have tried several things but nothing works - Much appreciation

 

[simco]

Use the functions Left, Right and Mid.
Like: Left("String",2) is going to return "St" (first 2 caracters from the string. (You can read the Help file for more examples).

Simco