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 |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2004-09-27 : 13:50:06
|
| I have a field thatname taxPercent that has char(15) datatype and I need to convert it to decimal(7,2) please advise.Thanks.This is what I am trying to do is to insert into a a temp tableCreate table #temp (TaxPercent Decimal(7,2) null)insert #temp(TaxPercent)select CONVERT(Decimal, Taxpercent)from Taxwhat is the correct syntax to do this conversion? Anybody.Thanks.k |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-27 : 14:34:25
|
| have you tried reading books on-line? You are 99% of the way there, you seem to understand that you need to use the CONVERT() function, and you know you want to convert to a decimal(7,2), you know what column you wish to convert (Taxpercent) ... come on, you can do this !- Jeff |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-27 : 14:40:49
|
quote:
select CONVERT(Decimal, Taxpercent)from Tax
Surf On Dude! |
|
|
|
|
|
|
Convert Char to Decimal?