SQL wildcard character excluding

[sandlucky]

pls help

How exclude character from SQL wildcard query.

My Query> (I need to select Flowers doesnt contain color "H")

SELECT Genus, Species, Flowercolor
FROM Main
WHERE FlowerColor Like "[!H]*";

H can be exist in any order, It can be 1st character , 2nd, 5th or last. It doest really matter flower contains any other color (A-N). All i need to do is SELECT Genus, species and Flowecolor of Flowers which doesnt contain clor "H". Meaning of A-N color abbriviate are like this;

Red (A)


Orange (B)
Yellow (C)
Green (E)
Blue (G)
Violet (H)
Pink (I)
White (J)
Creamy (K)
Black (L)
Gray (M)
Brown (N)

pls help!

[Rixxe]

You really shouldnt post the same query 2 times, even with a slightly different question...

use 'not like'

Where FlowerColour not like '*H*'; or i think you can use the not equal to signs

[sandlucky]

It's not same but quite similar.
Thanx useful 4 reply.