Searching with like and \A

[Ruslan Zasukhin]

On 7/14/04 4:46 AM, "Scott Runkel" <srunkel at hypix.com> wrote:

> I'm sure there's a simple explanation, but...
> 
> I have about 770 records with various fields, one of which is called
> "alltext".
> It's type text, sementsize 1024, ascii, indexed, and indexed by words.
> 
> When I do the following, I get all records (which is correct):
> 
>   SELECT alltext FROM pir WHERE alltext like 'Pediatrics' NO_CASE
> 
> But when I do the following, I get only 1 record, in which "Pediatrics"
> happens
> to be the first word:
> 
>   SELECT alltext FROM pir WHERE alltext like '\APediatrics' NO_CASE
> 
> But I should still get all the records because they all have at least one
> mention of the word "pediatrics" in them. The same thing happens for any other
> term: 'boy' I get 304 hits, but '\Aboy' I get 0.
> 
> My goal is to avoid hits where the user typed, say, "form" and it's finding
> "information" and "formation" etc. also.
> 
> What am I doing wrong? (This is V4MD, but the same thing happens in Valentina
> Studio, so I don't think that's relevant.)

If I am not mistake

    \A  this is begin of line

You need "begin of word", it seems this is \B
Check RegEx docs


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------