Problem with Like Operator in Access 2000

Hi all,

I am new to this forum.

When i use a like operator in an SQL statement it is not returning any records.
Following is the Statement I have used.

SqlStr = "SELECT * from Contact_Mast WHERE Contact_Mast.First_Name Like '*" & FNA & "*' "

"FNA" is a string variable passed on to a function from a text filed.

Pls somebody help me !!!.

Thanks

As in SQL the wildcard is % and not *, I'd try

SqlStr = "SELECT * from Contact_Mast WHERE Contact_Mast.First_Name Like '%" & FNA & "%' "