While this is not ultimately what I wanted, I think I may have found a way to achieve my ultimate goal which is to find the computers that are on a subnet within site. I'm still intrueged to know if someone has a solution for my original question. If anyone has this goal, here is the SQL I used.
declare @SiteName nvarchar(250);
set @SiteName = 'Name of Site in Site Management';
with computers as (
select [guid],[name],[IP Address] from vComputer)
,subnets as (
select Subnet,[Subnet Mask]
from vSubnet
where [Guid] IN (select rsub.[Guid] from RM_ResourceSubnet rsub
inner join ResourceAssociation ra
on ra.ChildResourceGuid = rsub.[Guid]
and ra.ResourceAssociationTypeGuid = 'F71ABA8C-8823-44C8-A750-F03DE84DC5F6'
left outer join RM_ResourceSite rsite
on ra.ParentResourceGuid = rsite.[Guid]
where rsite.[Name] = @SiteName))
select computers.Guid from subnets,computers
where (select dbo.fnIsIPInSubnet(computers.[IP Address],subnets.Subnet,subnets.[Subnet Mask])) = 1