How to write sql query conditions in vb

TmpSource = "SELECT l.MsgId as the number, l.Mobile as the number, l.Send_datetime as the sending time, l.Sendtype as the sending type, l.SendResult as the sending result, l.MsgContent as the short message content "u.

+"FROM SendHistory l where Send_datetime like %" _

+Month+"%"

Supplement:

TMPSource = "Select L. Send _ Datetime as the sending time and l.MsgContent as the short message content" u

+"FROM SendHistory l where Send_datetime like +" _

+"'"+s+"'and Send _ datetime & gt“+ ss+"and Send _ datetime & lt"+ sover+"'"

Your quotation marks are in the wrong place.