I have values in my SQL Server 7 database that I'd like to display as $xxx,xxx.xx. Some of these values use the money datatype and others use float.<br><br>I'm building a string in a stored procedure that is eventually passed to Visual Basic. I want to format these values in the above format in the string that is passed. I've searched all through MSN and I couldn't find anything related to VB's FORMAT function in SQL Server.<br><br>Does Transact-SQL have any functions that could format these values for me?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formatting values in stored procedures
- Thread starter jeffypop
- Start date
Similar threads
- Locked
- Question
- Locked
- Question