FUNCTION
fPlate
Extracts plate 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.fPlate(plateID) as plate from PlateX
Input and output parameters
name
type
length
inout
pnum
int
4
input
0
@SpecID
bigint
8
input
1