aajcl
0
Newbie Poster
Recommended Answers
Jump to Posttry using IS NULL
read more here.
Jump to Postselect case when sl_pl_nl_detail.det_nominalcr is null then sl_pl_nl_detail.det_nominaldr else sl_pl_nl_detail.det_nominaldr end as some_name /*i think this can work for you too*/ select COALESCE(sl_pl_nl_detail.det_nominalcr, sl_pl_nl_detail.det_nominaldr) as some_name /*or this*/ SELECT ISNULL(sl_pl_nl_detail.det_nominalcr, sl_pl_nl_detail.det_nominaldr) as some_name
Jump to PostIs it that your full code? Because you are missing the "from" and "where" clause.
Eg. Select some_fields from some_tables where some_fields = some_values and some_other_fields = some_other_values.
Jump to Postwhere is the WHERE clause ?
All 14 Replies
debasisdas
580
Posting Genius
Featured Poster
aajcl
0
Newbie Poster
jbisono
51
Posting Pro in Training
aajcl
0
Newbie Poster
jbisono
51
Posting Pro in Training
aajcl
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
jbisono
51
Posting Pro in Training
aajcl
0
Newbie Poster
jbisono
51
Posting Pro in Training
aajcl
0
Newbie Poster
jbisono
51
Posting Pro in Training
aajcl
0
Newbie Poster
jbisono
51
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.