Creating Random number from 1 to 100 in SQL

Select ABS(CHECKSUM(NEWID())) % 6 for numbers less than 6

RIGHT(ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)),2) - for numbers between 01-99