Talonjpc (Visitor) Jul 29, 2002
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
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