Results 1 to 11 of 11

Thread: [RESOLVED]Distinct Help

Threaded View

  1. Aug 13th, 2008, 10:04 AM #1
    drawlings
    drawlings is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Location
    UK, Suffolk
    Posts
    319

    Question [RESOLVED]Distinct Help

    Hi all,

    I need to know if this is possible. I want to run a select statement that selects only the first 4 characters of the field and make sure there are no duplicates.

    Examples of some of the data:

    1234-01
    1234-02
    1234-03
    2222-01
    2222-03

    You see all I want returned is 1234 & 2222.

    Any ideas? I have tried "Select Distinct left(Ref,4) from Table" but this does not work

    Thanks
    Last edited by drawlings; Aug 13th, 2008 at 10:19 AM.
    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