I'd like to have a database field with wildchars. It's kind of reverse wildchar linq search. 

So my field would contain "100-50-\*", and I would like to find this, when i search for anything starting with "100-50-". So searches like "100-50-10", "100-50-3", "100-50-B" would all find my row.

Edit:
I'm not sure i explained this properly.
I don't know the contents of the database before the search. Field values could be "100-*" or "100-50-*" or "100-50-10". I would like all three records to show up, if i search for 100-50-10.

Thanigainathan's answer was actually pretty close to what i was looking for.