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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-07 : 08:55:10
|
| Himansu writes "Hello everyone,Is there a way to export a table with NULL values. I want the record, but don't want the NULL text in my output file. Let me know what you guys think.Have a good day.Himansu" |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-09-07 : 09:09:35
|
| Are you sure you're in the right forum??? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-07 : 09:53:22
|
so use isnull(col1, ''). more info would be nice...Go with the flow & have fun! Else fight the flow  |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-08 : 00:42:20
|
how are you exporting?when you export using dts, you can transform the null values. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-08 : 12:57:14
|
| In query analyzer press CTRL+T (This will make the results pane to text)Sub sequently fire the query in query analizer.The o/p will not contain NULLS. select and paste the results in a text file.------------------------I think, therefore I am |
|
|
|
|
|
|
NULL values