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 |
|
kalaivani
Starting Member
11 Posts |
 Posted - 2007-12-18 : 02:49:47
|
| Thank u Chirag....but i should display all the records of that table not only price column.consider the column price in titles table in pubs database. If the price of any record is not defined it should be retrieved as -9999. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-18 : 02:52:37
|
| [code]Select IsNull(col, -9999) as Price...from ...[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-18 : 03:00:48
|
quote:
Originally posted by kalaivani
Thank u Chirag....but i should display all the records of that table not only price column.consider the column price in titles table in pubs database. If the price of any record is not defined it should be retrieved as -9999.
Dont open a new thread. Continue with the topic where you already questionedMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-18 : 03:01:27
|
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Replace the NULL Values