Query on format of a field

[Guest]

Hi - I'm looking to query a field that has TIN (taxpayer id numbers) this is
entered in one of 2 ways either as an EIN (nn-nnnnnnn) or as a SSN
(nnn-nn-nnnn).

Is there a way that I can run a query that will give me just the
(nn-nn-nnnn) format?

Thanks,
DMarieD

 

[Rick Brandt]

Hi - I'm looking to query a field that has TIN (taxpayer id numbers)
this is entered in one of 2 ways either as an EIN (nn-nnnnnnn) or as
a SSN (nnn-nn-nnnn).

Is there a way that I can run a query that will give me just the
(nn-nn-nnnn) format?

Thanks,
DMarieD

SELECT *
FROM TableName
WHERE FieldName Like "???-??-*"