Weird E+006 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Weird E+006

Author

Topic

snarty
Starting Member

2 Posts

Posted - 2008-03-12 : 20:55:48

I'm trying to CAST an integer to a varchar and I keep getting e+006 in my result set. The reason I need to do this is so that I can combine 2 columns to return a string.

Here is my table:

incomeBracket | lowIncome(int) | highIncome(int)
-----------------------------------------------
1 1000001 5000000
2 5000001 10000000

Here is my query:

SELECT CAST(incomeLow AS varchar) + ' - ' + CAST(incomeHigh AS varchar) AS incomeRange
FROM IncomeBracket_Currency

How can I get my result to look like this:

1000001 - 5000000
5000001 - 10000000

Instead of what it is returning now:

1e+006 - 5e+006
5e+006 - 1e+007

The query works fine for values that have a character length of 6 and less.

Thanks in advance.

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2008-03-12 : 21:13:30

I can't reproduce it but this is really something you should do at the front-end.