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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
