Convert 4 decimal places to 2

This topic is locked

Convert 4 decimal places to 2	8/21/2003 8:30:13 AM
ASPRunnerPro General questions
author Hi, On step 5 I modified the query to convert the price (ItemValue) column from displaying 4 decimal places to 2 CONVERT(decimal(10,2),ItemValue) When running the asp page, the resoults are correct: $ 250,23 (from 250,2315). However, the column header ItemValue is left empty. What am I doing wrong? TIA Janet <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=152&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />


	admin 8/22/2003
	Janet, I would recommend to add field alias to your SQL query: `CONVERT(decimal(10,2),ItemValue) as [Item Value]` Also you can modify a label for this field on the formatting page. Sergey Kornilov Support team