FUNCTION
fFiber
Extracts Fiber from an SDSS Spec ID
The bit-fields and their lengths are: plate[16] mjd[16] fiber[10] type[6] index[16]
select top 10 dbo.fFiber(specObjID) as fiber from SpecObj
Input and output parameters
name
type
length
inout
pnum
int
4
input
0
@SpecID
bigint
8
input
1