[Archon]

Hey all,

I searched around a little but can't find an answer to my question.

In Calibre I have created a custom column called "Length". In it I store "Novel", "Novelette", "Novella", or "Short Story". Works great for sorting.

However, when I do an advanced search to eliminate other lengths with the following:
#length:"Short Story" - finds all the short stories
#length:"novella" - works great only finds novellas
#length:"novelette" - works great only finds novelettes
#length:"novel" - this one finds novels, novellas, and novelettes

It seems the search acts as a <find everything that contains "novel"> instead of <find everything that is an exact match of "novel">.

So I do a regular search with
=Novel
and it finds all the novels. Woohoo! Likewise =Novella, =Novelette.

However, =Short story gives me nothing. :-(
No joy in Mudville.

I guess I can use #length:"Short Story" and =Novel but when I don't know how something works I must haves it.
So...
Does anyone know how to get Calibre to do an exact match search on a custom column when doing an advanced search (e.g. #length:"novel") ?

And does anyone know how to get Calibre to ignore the space in the data in a custom column when doing a regular search (e.g. =Short story) ?

I have tried using all kinds of wild card characters like \ and * but no joy.
I am sure it is simple to those who do DB searches all the time but that would not be me.

TIA for constructive advice.
Archon