Hi,
    I have SQL 2000. I run the query:

Select Field1, Field2, Field1 / Field2 * 100 as [Answer] From Table1
....(Field1 =37 and Field2 = 50 and are Int datatype)

SQL Server returns 0 as the [Answer]

Is something wrong with my query or has anyone else had this problem?


Thanks in advance

J

Top 100 ... Order by in views SQL 2005 problem
Passing parameter from a recordset in a Stored Procedure
Help with Subquery and "Group By"
cumulative problem
problem with row(s) affected