I want to use an sql statement in my asp page and use the != condition can anyone help?
my sql is<BR><BR>Sql = "Select * from Test where VersionID =" & Versionid & "And TestID !=" & TestIDUsing<BR><BR>but it just doesn't work
...but not with Access. With Access you have to use <>
so does <> mean not equal?
and what error do you get? And what does the SQL statement look like at runtime (response.write it then response.flush). I notice that there's no space before the AND which would break it.