I have the following query
select UID FROM RaceCDC WHERE HierarchicalCode =
FROM RaceCDC WHERE Concept = 'Payson Apache')
What I want to do is to return NULL when the second select fails to find a match. So if 'Payson Apache' isn't in the table I want the complete statement to return NULL.
Can someone show me how to do this?