How do I search text within a text field that starts with B?

[Damon Pleasant]

I have a text field that I am using to store an Alphanumeric character, with alpha characters at the end of the string (for example, 13452-CG or 25789-BY).  A search of that specific custom field with "Custom Field" ~ "C*" doesn't find "13452-CG".  If I separate the string in the field to "13452 - CG", this search works.  

However, if I search "Custom Field" ~ "B*", it will not find "25789-BY" or "25789 - BY".  It will, however, find "25789- BB".

Is there a way for you search a text field for characters embedded in a string (and not starting with that character)?

[Alexey Matveev]

It is not possible to place a wildcard at the beginning of a word out of the box. You would need a plugin like Power Scripts or ScriptRunner