troubleshooting Question

Urgent: How i can Use IF Statemant in SQL Server ??

Avatar of SystemSys
SystemSysFlag for Saudi Arabia asked on
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2005
7 Comments1 Solution300 ViewsLast Modified:
hi all Experts ,,

i have this  sentence

SELECT Writer_code,[Member_Name], CAST(misc_col_flag as bit) as C1,CAST([all_misc_col_flag] as bit) as C2 FROM [ALWASAT_WRITERS] order by member_name


i want put if statement if the field misc_col_flag = null then set value for this field False
and Also same thing in all_misc_col_flag field if it = null then set for it value = false

i know statement in MS Access like this iif(

i want that in SQL Server 2005 Please

and thank you ,,

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros