Query Wont Work in ASP

[JohnBoy2005]

I've got an SQL Query

SQL ="SELECT tblUsers.User_ID, tblUsers.Assets FROM tblUsers WHERE tblUsers.User_ID = 9 AND tblUsers.Assets Like '*;10;*'"

This Query is straight out of MS Access and returns a result of 1 which is correct,

Run the same SQL in my ASP script and it returns a recordcount of 0

SET rstCheck = Server.Createobject("ADODB.Recordset")
SQL = "SELECT tblUsers.User_ID, tblUsers.Assets FROM tblUsers WHERE tblUsers.User_ID = 9 AND tblUsers.Assets Like '*;10;*'"
rstCheck.Open SQL,Conn,3,3

Response.Write(SQL & " - " & RstCheck.RecordCount)

Can't understand why

Cheers

John

 

[JohnBoy2005]

Sorry, just realised you use % and not *

Works fine now

Cheers

John

 

[gbaughma]

Good job in figuring it out.

Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com