>It works but the query that calls it does not see it because the GroupId is 0 and there's no GroupId to join on. I could add a Group to the Groups table called "All", but then I'd have to hide it in other places.
>
>What do you think?
>
>
You can do a LEFT JOIN with Groups and use IIF(Groups.GroupID IS NULL, 'All', Groups.GroupName)
If it's not broken, fix it until it is.
My Blog