FUNCTION fRegionContainsPointXYZ

Returns 1 if specified region contains specifed x,y,z point, else returns zero.

There is no limit on the number of objects returned, but there are about 40 per sq arcmin.
parameters
regionid bigint, -- Region object identifier
cx float NOT NULL, -- x,y,z of unit vector to this object
cy float NOT NULL,
cz float NOT NULL,
Sample call to find if regionID 345 contains the North Pole
select dbo.fRegionContainsPointXYZ(7,0,0,1)
see also fRegionContainsPointEq

Input and output parameters

name type length inout pnum

@cx float 8 input 2

@cy float 8 input 3

@cz float 8 input 4

bit 1 input 0

@regionID bigint 8 input 1

name	type	length	inout	pnum
@cx	float	8	input	2
@cy	float	8	input	3
@cz	float	8	input	4
	bit	1	input	0
@regionID	bigint	8	input	1