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 |
|
Ambikaa
Starting Member
43 Posts |
 Posted - 2008-08-22 : 11:18:59
|
| Hi ,i need a help. when i used this below query, i am getting wrong result SELECT prty_Price FROM tbl_Property WHERE cast(replace(replace(replace(prty_Price,'$',''),',',''),'.','') as int)>= '200000' AND (cast(replace(replace(replace(prty_Price,'$',''),',',''),'.','') as int)<= '400000') AND prty_Deleted=0outputprty_Price3456.7834,34672000002345443453453453453454.45 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-22 : 11:28:38
|
what is the result that you want ?What is the original value of prty_Price ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-08-22 : 13:05:11
|
| Duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109332 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
please help me