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 |
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
 Posted - 2007-10-08 : 04:39:16
|
| hi all...mycount = (cast(d.sss_er as varchar)).lensss_er is a datatype moneyerror : Cannot call methods on varchar.thanksRON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-08 : 04:41:21
|
mycount = len(cast(d.sss_er as varchar))
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-08 : 06:12:05
|
quote:
Originally posted by Peso
mycount = len(cast(d.sss_er as varchar(50)))
E 12°55'05.25"N 56°04'39.16"
MadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-08 : 06:16:18
|
quote:
Originally posted by cwtriguns2002
hi all...mycount = (cast(d.sss_er as varchar)).lensss_er is a datatype moneyerror : Cannot call methods on varchar.thanksRON________________________________________________________________________________________________"I won't last a day without SQL"
What are you trying to do?If you convert money to varchar, you will get wrong lengthdeclare @m moneyset @m=345345select len(cast(@m as varchar(50)))MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
lenght