query

[bumi]

I am trying to write an update query to obtain the ssn
without the hyphens.
This is what I have so far:
Left([ssn],3) & Right([ssn],2) & Right([ssn],4)
However I cant get the two middle numbers correct. For
example: if the SSN is 123-45-6789
I get 123896789
I have tried various combinations for the middle syntax
but cant seem to get the the two middle digits in the
right place. The last two digits in the SSN end up in
the middle. Does anyone know of which combination works?

 

[Jen]

Hi,

In order to get the middle 2 numbers, you need to use the
Mid() function.

Mid([ssn], 5, 2)

Regards,
Jen