nos
SELECT TOP 10 RIGHT('0000000' + CAST(TrnID AS VARCHAR(7)), 7) PaddedContactID FROM tbl_Trn_Payments GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)