FUNCTION  fObjType

Return the ObjType value, indexed by name

the ObjTypes can be found with
Select * from ObjType
Sample call to fObjType.
select top 10 *
from TiledTarget
where objType = dbo.fObjType('GALAXY')

see also fObjTypeN

Input and output parameters

nametypelengthinoutpnum
 int4input0
@namevarchar40input1