sql server 2008 r2 - SQL Where Statement Removing Contracts with 2nd "-" -

i've got table list of contracts:

ct-12345, ct-12346, ct-12347, ct-12347-b1, ct-12560-a1, etc. etc.

i need statement it'll exclude has -... @ end of contract. '%-%' exclude first 3 in final output, above example, ct-12347-b1 , ct-12560-a1 excluded while ct-12345, ct-12346, ct-12347 included. i'm using sql server r2. thoughts?

thanks,

joshua

try this:

where contract not '%-%-%'