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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-18 : 09:35:22
|
| Mark writes "Hi. I am new to SQL Server, and have a stupid problem I just can't solve.Problem:I have an INTEGER field that I want to convert to a character value, with commas in it. This is then used as part of a message body elesewhere in my aplication.i.e. 1000000 to be converted to 1,000,000I have tried cast and convert but just can't get it working.Woudl you be so kind as to show me how? I know how I'd do it in Oracle (sorry!!!) but am avidly trying to convert me (and the company) to SQL Server. Thanks ever so much for any help you may be able to give.regards,Mark." |
|
|
|
|
|
cast and convert