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""
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.
Question
Forum Locked
Posted - 05/16/2005 : 08:23:23
