Wildcard seacrh

[andyt_2005]

Hi all,
So my serch function works fine however i would like to add a wildcard (*) Its to do with reference numbers which begin with letters followed by a dash then numbers (AB-123) (qw-321)
So i would like to search without the letters but including the dash

rs.FindFirst "[FaultNumber]=""" & Text19 & """"

This is what im using, where would i put the wildcard? i have tried a few different combos but no joy yet.
A little help please?

[ItsMe]

I believe the following should work for requiring the user to enter the beginning of the text.
rs.FindFirst "[FaultNumber] LIKE '" & Text19 & "*'"

[andyt_2005]

Sorry i wanted the user to only enter the dash and the numbers,
rs.FindFirst "[FaultNumber] LIKE "*'" & Text19 & '"

Would this be right?
So i can just enter " -1234 "

[andyt_2005]

Sorry i wanted the user to only enter the dash and the numbers,
rs.FindFirst "[FaultNumber] LIKE "*'" & Text19 & '"

Would this be right?
So i can just enter " -1234 "

got it Thanks for your help!
rs.FindFirst "[FaultNumber] LIKE '*" & Text19 & "'"

[ItsMe]

Yup, I think you got it. You can have a wildcard on both sides too.
rs.FindFirst "[FaultNumber] LIKE '*" & Text19 & "*'"