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 |
|
cirugio
Yak Posting Veteran
90 Posts |
 Posted - 2012-08-20 : 16:12:12
|
| I have a simple query which preforms a replace within my sql server (2008). The replace just looks for a comma and tries to replace it with an underscore. It works fine when you view the data on the screen, but when I export it to excel and open the file in excel I get a little square box with a ? . I think it represents a horizontal tab. How can I get my sql query to not create a tab within my code. My query is basically this:select cusip, description,REPLACE(description,',' , '_') as 'Desc' from temp1 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 16:53:21
|
| how are you exporting it to excel? using OPENROWSET?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cirugio
Yak Posting Veteran
90 Posts |
Posted - 2012-08-20 : 17:45:45
|
| I think I found a work around. I am just going to concatenated " " around the field and then excel works. Thank you anyway. |
|
|
|
|
|
|
replace adds tab -excel show ? with box around it