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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-01-25 : 11:22:52
|
| I have a query and I need to be able to take negative numbers out of it, example -16495.00. I am not sure how to add it to my where clause. I was going to put clm_tchg <> ‘-‘ I know that isn’t right, but I don’t know how to write it. Please help, Thanks. |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-01-25 : 11:26:42
|
| Integer data type:clm_tchg > 0Character data type:clm_tchg NOT LIKE '-%' |
 |
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-01-25 : 11:28:58
|
| Thanks you for your help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-25 : 11:33:08
|
| duplicate post :-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96183 |
|
|
|
|
|
|
Where clause take out neg numbers