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 |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-02-18 : 16:22:46
|
| I don't want to list a data if there is like '%XXX%' on fields _to or _from. And i need to list like '%AAA%' (both _to or _from fields)select id, _from, _to from tblAWHERE (_to like '%AAA%' Or _From like '%AAA%' OR _to NOT like '%XXX%' OR _from NOT like '%XXX%')I mean i just need list where _to or _from not like '%AAA%' AND _to or _from like '%XXX%' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
how to use AND OR