Results 1 to 3 of 3

Thread: DISTINCT question

  1. 04-06-2004, 06:51 AM #1
    Styles
    Styles is offline Registered User
    Join Date
    Jun 2003
    Location
    NJ
    Posts
    8

    DISTINCT question

    Hi everyone!

    I have what I'm sure is a simple question. In a table, (ms sql), I have a numeric field called ID, then many text fields like LastNAme, FirstName, Address, etc. The ID isn't an autoincrement, it's assigned to each person whose info is being collected. I want to make a view where the ID numbers are Distinct, and the rest of the user's information comes with it. BUt I get an error message saying something like I can't do a distinct sort on those fields because they're text.

    If anyone has any insight on how to pull this off, I'd greatly approciate it!
    Thanks!
    Reply With Quote Reply With Quote
  2. 04-06-2004, 10:36 AM #2
    jkoopmann's Avatar
    jkoopmann
    jkoopmann is offline Registered User
    Join Date
    Mar 2003
    Posts
    468
    please post your current sql that you are using and the error message along with it.
    Reply With Quote Reply With Quote
  3. 04-06-2004, 12:28 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If the data type is text you can't do it. Change the data type to varchar, if this is not possible use substring function in your query for all text columns.
    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