Results 1 to 2 of 2

Thread: Comparing fields

  1. 05-22-2003, 01:53 AM #1
    OtarBoy
    OtarBoy is offline Registered User
    Join Date
    Jan 2003
    Posts
    30

    Comparing fields

    How do i return the records with the first 2 digit of the serial number beginning with 02? Can anyone provide with the code?

    SELECT *
    FROM TABLE
    WHERE ......................

    I tried the LIKE method but it can't seem to work with the ACCESS. So are there other ways?
    Reply With Quote Reply With Quote
  2. 05-22-2003, 02:10 AM #2
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    1)Select * from Table where field LIKE "02*"

    2)Select * from Table where Left (field, 2) = "02"
    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