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!
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!
Comment