On Sat, Sep 10, 2005 at 17:45:50 +0200,
Michael Hoeller <MichaelHoeller(at)t-online(dot)de> wrote:
> 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.
Your description isn't as precise as would be nice. But from what I can figure
you want:
code ~ '^k[^V]'