Michael Hoeller 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.
SELECT * FROM my_table
WHERE code = 'k'
AND code <> 'kV'
;
HTH
--
Richard Huxton
Archonet Ltd