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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2002-10-31 : 02:59:33
|
| Dear all, how to make a query changing record "NULL" TO 0oh |
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2002-10-31 : 03:04:19
|
| Have a look at the ISNULL() function in Books Online.macka. |
 |
|
|
u2p_inst
Yak Posting Veteran
78 Posts |
Posted - 2002-10-31 : 03:16:16
|
| sorry i'am a newby can you tell me the script to change record "null" to 0oh |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 03:34:06
|
quote:
sorry i'am a newby can you tell me the script to change record "null" to 0oh
The other poster practically did. Have a look in the SQL Server Books OnLine (The help file that appears if you select TRANSACT SQL Help from Query Analyzer) and look up ISNULL function in the contents.It will be along the lines ofSELECT isnull(thing,0) as fieldname |
|
|
|
|
|
|
null to 0