How Can I search for a "*" in a text box.

[jbleoo]

When I enter in the criteria like * , it gives me everything. I know that * is a wild card. I have text with the * in it that I need to filter out.

Thanks
Jason

 

[Ed2020]

WHERE ((InStr(1,[TableName]![FieldName],"*")>"0"));

Ed Metcalfe.

Please do not feed the trolls.....

 

[TheAceMan1]

How are ya jbleoo . . .

[blue]WHERE ([purple][b][i]Your Criteria[/i][/b][/purple]) AND (InStr(1,[purple][b][i]TableName[/i][/b][/purple]].[[purple][b][i]FieldName[/i][/b][/purple],"*")=0);[/blue]

See Ya! . . . . . .

 

[jbleoo]

Thanks All

 

[PHV]

Like '*[*]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886