Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhig2002
Starting Member
2 Posts |
 Posted - 2002-09-24 : 01:24:28
|
| hello my problem is that when i am inserting a record from asp pages to field which data type is money when i am inserting 20000 what i want 20,000 instead of 20000 how can i insert , after 20 or when i write 200000 it take 2,00,000 so how is this possible in sql pls tell me as quickly as possible pls be fasti am very greatful to uabhishekEdited by - abhig2002 on 09/24/2002 01:28:35 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-24 : 02:42:23
|
| The money data type will take the value. It doesn't hold it with any commas.When you retrieve the value you have to format it for display - that is when you can add any commas or not.The commas are the default for sql server converting money datatype to character - it's up to you what you do with it.What's this got to do with a subquery?==========================================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.Edited by - nr on 09/24/2002 02:54:21 |
 |
|
|
|
|
|
subquery problem.