FUNCTION  fSecTargetN

Returns the expanded SecTarget corresponding to the flag value as a string

the photo and spectro secTarget flags can be shown with Select * from SecTarget
Sample call to find photo objects that are Galaxy primary targets
select top 10 objId, dbo.fSecTargetN(secTarget) as secTarget
from photoObj

see also fSecTarget, fPrimTarget

Input and output parameters

nametypelengthinoutpnum
@valueint4input1
 varchar1000input0