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 |
|
trento
Starting Member
13 Posts |
 Posted - 2009-10-05 : 20:11:20
|
| Hi,trying to get output into the file for COL01 [int].didselect convert(int, (PositionLimit)), char(7) from T1 adn get some weird output, anybody can help to get into numeric?TxTrent |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-06 : 02:03:26
|
| Not sure if this is what you wantselect convert(char(7), PositionLimit) from T1 adnMadhivananFailing to plan is Planning to fail |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-10-06 : 12:32:06
|
| This might help you to get more helpful response:[url]http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx[/url] |
|
|
|
|
|
|
convert/cast int into dec(char)