Update column with random range number

create random number that fall between range (0.28 - 0.57).

Query

SELECT      0.28 +             (SELECT     ((ROUND((RandumNumber.RandumNumber*100)/3,0))/100) -                         (ROUND((RandumNumber.RandumNumber*100)/25,0)/100)             FROM        (SELECT    (ABS(CHECKSUM(NEWID()))%100)/100.0 AS                             RandumNumber)RandumNumber) GO 5

Output

Reference
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=190503