finding records matching an approximate value

From: Ken (Ken_at_discussions.microsoft.com)
Date: 01/04/05


Date: Tue, 4 Jan 2005 09:41:01 -0800

I would like to search a pile of records with a field matching all the
characters from a field in a form, but it doesn't have to be exact.
for example the field on the form may be: "d86-934"
and the field in the record could be: "00d86934"

Is this possible with something like this?
SELECT records FROM records
WHERE (((records.CONT_NO) Like
[Forms]![Select_SH_NUM]![ROAD_HIST_TBL2].[Form]![CONT_NUM]));
Any help is greatly appreciated.