Criteria with SQL LIKE Problem.

[Talonjpc]

I know the SQL LIKE command allows someone to search for a value that matches part of the criteria. However, how do you use the LIKE command with User entered criteria. I want the user to enter a server's network name, so in the criteria I put Like [Network Name] However the []means something different with the LIKE command, I know that much, so Database will not prompt the user for the Network Name
So my question is, how can I use this command with user based criteria.

Thanks,
Vinay

 

[MikeDNova]

try writing it the same way but put a "p" in front of network name. Like this:

Like [pNetworkName]

the user should now be promted for the network name.

-Mike