dbaSQL
asked on
silly question re DECIMAL
what is the EXACT decimal value for '100', or 100 % ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
decimal (5,3) can store upto 99.999 while decimal (6,3) can store upto 999.999
ASKER
and the correct way for them to give me 100 ? (100 %)
ASKER
just 100, right?
declare @1 = decimal(6,3)
set @1= 100
select @1 = '100.000'
yes?
declare @1 = decimal(6,3)
set @1= 100
select @1 = '100.000'
yes?
ASKER
yep. thank you, aneesh
ASKER
0
.50
1
10.25
50
75.9
100
just looking for the best way to define the attribute