using CONVERT VARCHAR with DISTINCT in Select

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GregM56
    New Member
    • Jan 2015
    • 2

    using CONVERT VARCHAR with DISTINCT in Select

    I can
    SELECT CONVERT(VARCHAR (8), DXACCNUM)
    but I cannot
    SELECT CONVERT(VARCHAR (8),DISTINCT(DX ACCNUM))

    I am merely trying to make that int column 8 char wide.

    Any ideas from anyone?
    Thanks!
    Last edited by GregM56; Jan 19 '15, 07:47 PM. Reason: clarity
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    select distinct convert(varchar (8),dxaccnum)

    Comment

    • GregM56
      New Member
      • Jan 2015
      • 2

      #3
      Thank you so much Rabbit!

      Comment

      Working...