replace null with text information

Question

replace null with text information

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Use ISNULL or COALESCE

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

Yep, ISNULL or COALESCE, but...

In order to mix string "No Data" with numerics in the same columns, you will need to convert all of them into varchar. This sort of staff is better to be done in a client app or in a report.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

Eugene Elutin (11/9/2012)
Yep, ISNULL or COALESCE, but...
In order to mix string "No Data" with numerics in the same columns, you will need to convert all of them into varchar. This sort of staff is better to be done in a client app or in a report.

He's already converting to char using the STR function.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2