Hey all,
I ned to do a where statement like this....
WHERE M.Region IN (
CASE @region
WHEN 'Southwest' THEN '''Southwest''' + ',' + '''N/L'''
ELSE @Region
END
)
Where if the @region variable is Southwest i need to get all values IN ('Southwest','N/L') but if it's any other region I just need to get that region's values. Does that make sense?
CASE @region
WHEN 'Southwest' THEN '''Southwest''' + ',' + '''N/L'''
ELSE @Region
END
)
Where if the @region variable is Southwest i need to get all values IN ('Southwest','N/L') but if it's any other region I just need to get that region's values. Does that make sense?
The above code validates, but it does not return any results. Any thoughts?
Ryan
_______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://lists1.safesecureweb.com/mailman/private/list http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
