Generate resume number (eg. RE00000XXXX)

Resume number generation function: Scalar Value Function

/*
Author: xingbaifang
DateTime: 2007-10-15
*/
Create Function Job_GetREID (@ PKId int)
Returns varchar (50)
Begin
Declare @ TempValue int
Declare @ REID varchar (50)
Declare @ CurrentDate varchar (50)
Set @ PKId = @ PKId
Set @ CurrentDate = Convert (varchar (50), getdate (), 112)
Set @ TempValue = 100000000 + @ PKId
Set @ REID = substring (cast (@ TempValue as varchar (20), len (cast (@ TempValue as varchar (20)-7, 8)
Set @ REID = 'Re' + @ REID -- RE00000XXX
-- Set @ REID = 'Re' + @ CurrentDate + @ REID -- RE2007101500000XXX
Return @ REID
End

The call is as follows:
Select dbo. Job_GetREId (10)
Output:
RE00000010