Random 4-digit number Posted on 07/11/201607/11/2019 by admin select substring(cast(abs(CAST(CHECKSUM(NEWID()) AS bigint)) as varchar),1,4);