Select Distinct

Results 1 to 3 of 3

Thread: Select Distinct

  1. #1
    Ed R Guest

    Default Select Distinct

    can someone explain how to fix this...<BR>SQL Server 7.0 table has a field defined as nvarchar, <BR>I use it to load into a pick list.... <BR>This is what it looks like...<BR><BR>SELECT Distinct rc from <BR>table<BR>order by rc asc<BR><BR>00 How can I get the 1200 and 13000 to sort<BR>1200 after the 82...<BR>1300 Thanks<BR>51<BR>55<BR>82

  2. #2
    brother love Guest

    Default RE: Select Distinct

    probably need to cast them as some kind of numeric type rather than a varchar

  3. #3
    Ed R. Guest

    Default RE: Select Distinct

    How would the syntax be with a Select Distinct and Cast because<BR>whatever I try, is being rejected... Any ideas....Thanx

Posting Permissions

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