FUNCTION  fSecTarget

Returns the SecTarget value corresponding to a name

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 *
from photoObj
where secTarget & dbo.fsecTarget('TARGET_SPECTROPHOTO_STD') > 0

see also fPrimTarget, fSecTargetN

Input and output parameters

nametypelengthinoutpnum
 int4input0
@namevarchar40input1