Can i put a select in an ISNULL Statement?

Question

Post reply

Can i put a select in an ISNULL Statement?

jeffshelix

SSCrazy

Points: 2257
More actions
March 8, 2018 at 11:48 am

#344338

crude example,
the REAL price might not be in DBO.RealPrice,but it will be in DBO.OLDPRICE.
Can i do something like this:
Select
yada A,
yada B,
,ISNULL(RealPrice, Select OLDPRIOE from DBO.OLDPRICE...)
trying to save some time

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

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

dogramone Hall of Fame Points: 3216 More actions · Answer 1

Have a look a coalesce and see if it meets your needs MS coalesce article

ZZartin SSC-Dedicated Points: 30894 More actions · Answer 2

You can but only if the sub query will only return 1 or no rows.

Michael L John One Orange Chip Points: 27038 More actions · Answer 3

jeffshelix - Thursday, March 8, 2018 11:48 AM
crude example,
the REAL price might not be in DBO.RealPrice,but it will be in DBO.OLDPRICE.
Can i do something like this:
Select
yada A,
yada B,
,ISNULL(RealPrice, Select OLDPRIOE from DBO.OLDPRICE...)
trying to save some time

Yes, but why would you want to?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

jeffshelix SSCrazy Points: 2257 More actions · Answer 4

yea, I think i over thought this . . . agreed, thanks , Solved