Results 1 to 4 of 4

Thread: [RESOLVED] SQl query

  1. Jul 19th, 2006, 10:12 AM #1
    engnouna
    engnouna is offline

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2006
    Posts
    977

    Resolved [RESOLVED] SQl query

    Hi
    I have an SQL server 2000 table that has a field called "Files".
    I execute the following query:
    Rs.open"Select Files from Books where BDate like ' &sdate1 & "'",cnn,adopenStatic,adlockoptimistic
    it returned the following recordset
    01daily.doc
    05daily.pdf
    04daily.doc
    19daily.doc
    16daily.doc

    Now i want to select the record whose Files value begins with the highest number,in this case
    it's 19daily.doc

    how can i do it?
    thanks in advance
    Reply With Quote Reply With Quote
  2. Jul 19th, 2006, 10:15 AM #2
    TheBionicOrange
    TheBionicOrange is offline
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Re: SQl query

    Try this :

    VB Code:
    1. Rs.open"Select Files from Books where BDate like '" &sdate1 & "' order by Files desc",cnn,adopenStatic,adlockoptimistic
    Reply With Quote Reply With Quote
  3. Jul 19th, 2006, 10:15 AM #3
    TheBionicOrange
    TheBionicOrange is offline
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Re: SQl query

    .. or if you JUST want the highest value, then :

    VB Code:
    1. Rs.open"Select max(Files) from Books where BDate like ' & sdate1 & "'",cnn,adopenStatic,adlockoptimistic
    Reply With Quote Reply With Quote
  4. Jul 19th, 2006, 12:18 PM #4
    engnouna
    engnouna is offline

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2006
    Posts
    977

    Re: SQl query

    thanks the BionicOrange
    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