FUNCTION  fSpecZStatus

Return the SpecZStatus value, indexed by name

the SpecZStatus values can be found with
Select * from SpecZStatus
Sample call to fSpecZStatus.
select top 10 *
from SpecObj
where zStatus = dbo.fSpecZStatus('XCORR_LOC')

see also fSpecZStatusN

Input and output parameters

nametypelengthinoutpnum
 int4input0
@namevarchar40input1