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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-16 : 08:23:23
|
| priyabrat routray writes "i have a table named as PersonDetails.having fields PersonID ,PersonName.I have some records .The personName field contains some records like "ABC DEF","ABC","XYZ ABC","ABC KKKSS".I want to retrive some records which personname does not contain the word "ABC" but i want to retive records which personname field contain the value"ABC DEF"" |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-16 : 08:51:33
|
| select * from PersonDetails where PersonName = 'ABC DEF' |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-16 : 13:21:03
|
| select * from PersonDetails where PersonName = 'ABC DEF' or PersonName not like '%ABC%'Any other guesses as to what the question is?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-16 : 14:33:19
|
Occam's razor. Simple explanation is the right one  *need more coffee* |
|
|
|
|
|
|
Question