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.
Author |
Topic |
mcinvalek
Starting Member
5 Posts |
Posted - 2014-04-23 : 21:30:29
|
I ran a large query and exported it to xls. In Excel, I noticed a value of '2.00E+01'. I formatted the Excel cell and then got a value of '20'. I searched for the record in SQL Server 2008, ya I know, ancient. The value is '2E1' which excel is seeing as scientific notation. Can I use a case statement that when an 'E' is present to add a single prefix quote like '2E1? Or perhaps do it for the whole column? Or put put double quotes around the whole field?Any and all advise is greatly appreciated_keith |
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2014-04-23 : 21:39:44
|
why don't jus add single quote to the column? select ''''+problem_column from table |
|
|
mcinvalek
Starting Member
5 Posts |
Posted - 2014-04-23 : 22:41:57
|
thank you waterduck!! My SQL skills are quite rusty. I tried a few different ways even using a \ and was unable to figure it out. You have save me much time and heart ache_keith |
|
|
|
|
|