The following would NOT work
case when e.myCode = null then e.yourCode else e.myCode end as displayCode
instead use below
,isnull(e.myCode,e.yourCode) as displayCode
hope this helps
Showing posts with label NULL Case statement SQL. Show all posts
Showing posts with label NULL Case statement SQL. Show all posts
Thursday, November 4, 2010
Subscribe to:
Posts (Atom)
