hello,
i use this sql statement to generate random number
Select ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT))/10000 as code
it works fine. some time it genrates 6 digit some times it generates 5 digit i want that it should always generate 5 digit please advice what change needed in this thanks