FUNCTION  fSpecClass

Returns the SpecClass value, indexed by name

the SpecClass values can be found with
Select * from SpecClass
Sample call to fSpecClass.
select top 10 *
from SpecObj
where specClass = dbo.fSpecClass('QSO')

see also fSpecClassN

Input and output parameters

nametypelengthinoutpnum
 int4input0
@namevarchar40input1