I have a data table that has a customer number in it. This is a number with many digits in it. I'm storing it as a number because that takes less space than a character string.
When I query CUST_ID I get data that looks like this:
What I want to see is
How can I get this? I am using SQL Server 2008