sql server 8.0 - Function and format to get 2 digits after decimal points

Hi Experts,
Can someone please help me with this basic question. I need to get 2 digits after decimal point in sql server. Doing the following in sql query analyzer;
select 10/3 gives me 3.  I need to get 3.33
If I do the calculations inside the stored procedure, same thing happens and I do not get digits after decimal. Thanks
uzairpAsked:
Who is Participating?
 
TDSnetCommented:
SELECT CONVERT(DECIMAL(10,2), CONVERT(REAL, 10) / 3)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.