Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JVRudnick
Starting Member
4 Posts |
 Posted - 2001-10-30 : 05:41:23
|
| Hello all..I am constructing a querystring in a page using user entered terms, and once made, I wish to pass that SQL statement as a querystring to a subsequent page to display the recordset.In that querystring, I use the LIKE predicate and the % (percentage sign) as well.But each time the querystring gets passed, the % ends up NOT getting passed...it turns into *something* else...ie it ain't a % anymore.Can someone help here? Heres a test querystring...how do I pass the % as part of it....SQL = "select * from tblVehicles where model like '" & chr(37) & request.form("Model") & chr(37) & "'"??????????Jim |
|
|
|
|
|
Passing a % in a queryString -- how to?