SQL question

Results 1 to 2 of 2

Thread: SQL question

  1. #1
    KatieG Guest

    Default SQL question

    How would I rewrite the WHERE criteria in this SELECT statement so that it will work in my ASP page? The asterisk does not work??<BR><BR>SELECT Cruises.Cruise_Id, Cruises.Dep_Date<BR>FROM Cruises<BR>WHERE (((Cruises.Dep_Date) Like "*/01/01"))<BR><BR>Also, my dates are in the DD/MM/YY format. I would like to ORDER My search results by date but when I do this, the records are ordered by day first regardless of the month or year. Is there a way to rectify this?<BR><BR>Thanx in advance<BR>Catherine<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL question

    you have to use % not*

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts