[V4MD] search like "*"

[Ruslan Zasukhin]

On 5/29/05 10:54 PM, "Scott Runkel" <srunkel at hypix.com> wrote:

Hi Scott,

> How does Valentina SQL (V4MD) treat the "*" character?
> 
> I'm using this SQL:
> 
> SELECT *, recid FROM pir WHERE (alltext like 'hyperlipid*' NO_CASE)

I assume you use V4MD1. And you try do REGEX search ?

    alltext like 'hyperlipid*'
                    ^^^^^^^^^^^^

You want get strings that CONTAINS hyperlipid ?
Then just remove STAR.

 
> And it's finding lots of results even though I don't think any of them
> literally
> have "hyperlipid*" in them. I think it's finding things like "hyperlipidemia".
> It's not a problem, but I'd just like to know what's happening.
> 
> What I really want is a way to replace the user's "*" in such a way that I can
> search for beginnings and endings of words. Like
> 
> gastro*
> to search gastrointestinal, gastroenterologist, gastro-anything
> 
> or *emia
> to search anemia, hyperlipidemia, or anything-emia.
> 
> I've tried \A at the beginning of my searches and it doesn't seem to help.
> What am I missing?

If I am not mistake the \A is start of line.

You need start of word   \B (it seems)

Check RegEx docs


> "SELECT *, recid FROM pir WHERE (alltext like '\Ahyperlip' NO_CASE)"
> 
> returns no results at all.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]