FUNCTION fRegionOverlapString

Returns the overlap of a given region overlapping a regionString

The parameters
@regionid is the region we want to intersect with
@regionString is the region of interest
@buffer is the amount the regionString is grown in arcmins.

Returns a string with the overlap region,
null if input params are bad.
regionString varchar(7500) -- the string defining the intersection SELECT * from fRegionOverlapString(1049,'CIRCLE J2000 195 2.5 100',1)

Input and output parameters

name type length inout pnum

@regionid bigint 8 input 1

@regionString varchar 8000 input 2

@buffer float 8 input 3

varchar 7500 output 0

name	type	length	inout	pnum
@regionid	bigint	8	input	1
@regionString	varchar	8000	input	2
@buffer	float	8	input	3
	varchar	7500	output	0