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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

values pattern

Status
Not open for further replies.
nirs

nirs

IS-IT--Management
Apr 4, 2003
37
IL
hello
is ther any command or set of commands that i can use to change a numeric value
pattern (e.g. 3.5 into 3.50 or 3 into 3.00) like "FORMAT" in VB
thank you
 
Sort by date Sort by votes
convert(varchar(21),convert(decimal(18,2), fld))



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Working Days giving NULL values
Replies
8
Views
213
Cpreston
Cpreston
kingz2000
  • Locked
  • Question
select data with date condition, choosing latest values from selected dates 2
Replies
16
Views
207
Andrzejek
Andrzejek
scabral1979
  • Locked
  • Question
Aggregate Values By Group
Replies
1
Views
87
imex
imex
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
130
Andrzejek
Andrzejek
Brianfree
  • Locked
  • Question
SQL Rank() But move 0 values to bottom of Rank?
Replies
1
Views
106
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top