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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-17 : 11:45:25
|
| How can this query be fixed please?Thanksdelete from tblMain where ID = 1 and operator = 'NOT IN' and value = '('EUR', 'JPY')'error is : Incorrect syntax near 'EUR'. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-01-17 : 11:51:11
|
| [code]delete from tblMain where ID = 1 and operator = 'NOT IN' and value IN ('EUR', 'JPY')[/code]That's just a guess. If that is not right try explaining what you are trying to do in words. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
delete