[dba-SQLServer] SQL Server 2008 Display Formatting Problem

Stuart McLachlan stuart at lexacorp.com.pg
Fri May 25 18:00:40 CDT 2012


Because you have used it incorrectly?

To use a expression commonly found in programming forums: 
"Code Not Shown!"

Post the problem line(s) and we are more likely to be able to help.

-- 
Stuart

On 25 May 2012 at 17:41, Alan Lawhon wrote:

> 
> I modified the code (slightly) from what is given in the book.  In the
> section of code that calculates a 50% payment, I used the CONVERT function
> to try and modify the output display of the "Payment" calculated field.  (I
> wanted the calculated value of 3470.1250000 to display as character string
> 3,470.13 so that it looks more "money" like.)  However, the CONVERT function
> is not working as I expected.
> 
>  
> 
> Does anyone have an idea as to why the CONVERT function is not working as
> expected?
> 
>  
> 
> TIA,
> 
>  
> 
> Alan C. Lawhon
> 
--
Stuart McLachlan

Ph:    +675 340 4392 
Mob: +675 7100 2028
Web: http://www.lexacorp.com.pg



More information about the dba-SQLServer mailing list