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
 General SQL Server Forums
 New to SQL Server Programming
 single quote before a value

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -