SQL Syntax for Like

[Devil's Angel]

Hey everyone!

This is probably a realy easy fix that I'm overlooking. I always mess up the syntax for SQL.

I'm trying to do a like on a date field.

On one page I have the user select a month which is in a querystring. The next page takes the string and changes it slightly so I can compare it to a date field in my database. My code:

Month = QueryString("Month")

If Month = "1" Then
Month = "1%"
End If

I make it change to 1% because to do a like you add % after so it looks for everything that starts with 1.

sql = "SELECT select bunch of fields including date of publication WHERE [News-Clippings-Information].[Date of Publication] LIKE 'Month' "

Now this doesn't output anything....the Month variable does output 1% if I just call <%=Month%>

If I use the same statement above but replace 'Month' with '1%' it works fine. So I tried just Month...error...I tried "Month"....error...I tried a whole bunch more...still error.

I'm sure it's just a small stupid syntax error...but if someone could point it out I would much appreciate it!

[hatchet]

I'm assuming you're using a submission form or a string in the URL.. find.php?month=2
Right before you call your sql statement just concatenate the % sign on the end..
In php it would be
$month = $_GET[month].'%';
then in the select statement you would have
Publication] LIKE '$month'";

[ILoveJackDaniels]

You aren't using the variable month. You're using the word Month.

[code:1:627fdafba4]sql = "SELECT select bunch of fields including date of publication WHERE [News-Clippings-Information].[Date of Publication] LIKE '" & Month & "' "[/code:1:627fdafba4]

You might want to be a bit careful of SQL injection too...

[code:1:627fdafba4]Month = replace(Month, "'", "''")[/code:1:627fdafba4]

[Devil's Angel]

Originally Posted by ILoveJackDaniels

[code:1:75776b7560]sql = "SELECT select bunch of fields including date of publication WHERE [News-Clippings-Information].[Date of Publication] LIKE '" & Month & "' "[/code:1:75776b7560]

Thanks! That worked perfectly!