FUNCTION  fProgramType

Return the ProgramType value, indexed by name

the ProgramTypes can be found with
Select * from ProgramType
Sample call to fProgramType.
select top 10 *
from Tile
where programType = dbo.fProgramType('MAIN')

see also fProgramTypeN

Input and output parameters

nametypelengthinoutpnum
 int4input0
@namevarchar40input1