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 |
|
esambath
Yak Posting Veteran
89 Posts |
 Posted - 2009-06-15 : 11:43:49
|
| Hai,I have two table,1.select * from CC_ServicesPrice--Varchar121212323122.select * from CC_MoneyExchangeEuro--varchar7.4I try below query,select (a.Price/m.EuroExchange)from CC_Services as a cross join CC_MoneyExchange as m I face Server: Msg 403, Level 16, State 1, Line 1Invalid operator for data type. Operator equals divide, type equals varchar.Thanks in Advance |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-06-15 : 11:54:06
|
| Converting a varchar to int can be done like this:SELECT CONVERT(int, '5')Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
|
|
|
|
|
Convert Varchar to int