Syntax for Like

  • Thread starter Thread starter PrestonM
  • Start date Start date
P

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
 
-----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"
Click to expand...
 
-----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
.
Click to expand...
Click to expand...

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
Click to expand...
 
Back
Top