convert null to zero in sql server 2005
-
Nz([fieldname],0) not working Select MAX(UploadID) as id from fshUploadedMaster in above query if no record then returning null but I want to replace null by 0(zero) if returning null thanks
You get the best out of others when you give the best of yourself.
-
Nz([fieldname],0) not working Select MAX(UploadID) as id from fshUploadedMaster in above query if no record then returning null but I want to replace null by 0(zero) if returning null thanks
You get the best out of others when you give the best of yourself.
select COALESCE(MAX(UploadID), 0) as id from fshUploadedMaster In future please ask SQL questions in the SQL Forum.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Nz([fieldname],0) not working Select MAX(UploadID) as id from fshUploadedMaster in above query if no record then returning null but I want to replace null by 0(zero) if returning null thanks
You get the best out of others when you give the best of yourself.
-
select COALESCE(MAX(UploadID), 0) as id from fshUploadedMaster In future please ask SQL questions in the SQL Forum.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
ok thanks
You get the best out of others when you give the best of yourself.