Hello,
sometime you have to write a mail and your brain gets cleared...
select a.code
from stamm a
where
a.skart in (
(select skart
from stamm
where code like '%k%')
)
and a.code not like '%V%';
May be this is not nice but this brings back the list I have.
Michael
--- Begin Message ---
Hello,
I would like to select every row which has got in the column CODE a "k"
but I want to exclude every "kV" -- may be it is due to the fact that
it is Saturday and I work too long I don't get it.. I tried a
subselect, union but I struggle with the two select creteria on one
column.
Can some one help me -- hope this is not a too stupid question. Normally
google is my friend but also there I did not find a solution.
Thanks a lot
Michael
--- End Message ---
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
