Results 1 to 3 of 3

Thread: sql :like

  1. Sep 4th, 2002, 04:06 AM #1
    dadazhu
    dadazhu is offline

    Thread Starter
    Lively Member dadazhu's Avatar
    Join Date
    Oct 2001
    Location
    Opera House
    Posts
    126

    sql :like

    hi, all

    Can anyone tell me what is wrong with this:

    strQry = "select * from ticket where " + _
    "[record date] <= #" & date1 & "#" + _
    "and [Flight NO] like ' ' " & text1 & " '* ' "

    Thank you in advance.
    I wish 49.9999999% of my dreams have come true
    Reply With Quote Reply With Quote
  2. Sep 4th, 2002, 04:09 AM #2
    digisenze
    digisenze is offline
    Member
    Join Date
    Jul 2002
    Location
    Sweden
    Posts
    40
    try this:

    strQry = "select * from ticket where " + _
    "[record date] <= #" & date1 & "#" + _
    "and [Flight NO] like '" & text1 & "%'"
    Reply With Quote Reply With Quote
  3. Sep 4th, 2002, 04:14 AM #3
    dadazhu
    dadazhu is offline

    Thread Starter
    Lively Member dadazhu's Avatar
    Join Date
    Oct 2001
    Location
    Opera House
    Posts
    126
    Thank you ,digisenze.

    It worked!
    I wish 49.9999999% of my dreams have come true
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width