Generate 5 digit random numbers in SQL Server

Last Reply one year ago By dharmendr

Posted one year ago


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

You are viewing reply posted by: dharmendr one year ago.