Syntax for Like

[PrestonM]

Case 4
strSQL = "SELECT * from Staff Staff.Rtype
Like '2*' ORDER by DJ ASC"

I can't seem to get the syntax right for using the like
operator.

Any help?

Preston

 

[Preston]

-----Original Message-----
I did leave that out, but it still does not work, here's
the new code:

Case 4
strSQL = "SELECT * from Staff WHERE [RType]
Like '2*' ORDER by DJ ASC"

 

[Jeremiah Ellison]

-----Original Message-----
I did leave that out, but it still does not work, here's
the new code:

Case 4
strSQL = "SELECT * from Staff WHERE [RType]
Like '2*' ORDER by DJ ASC"

forgot the WHERE statement?
Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts
.

Except for table and field names, I don't suspect anything could be wrong. Try looking elsewhere for the problem?
Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts