B.A.Query-Using CONTAINS Comparison

Will do, thanks Stephen.

Stephen Edginton <stephene@...> wrote: Bill, Try Matches in place of contains.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bill Jackson
Sent: 04 May 2007 14:20
To: vantage@yahoogroups.com
Subject: [Vantage] B.A.Query-Using CONTAINS Comparison

Vantage 6.10 -Developed a BAQ , trying to find PartDescription that
contains a certain bit of text, using 'CONTAINS' Comparison Operator (
in this case, text = "shaft":
I have tried every syntax scenario I can think of , with and without *
wildcard, ie:
'shaft*', "shaft*', 'shaft', "shaft" , the Query just locks up, even
though the 'statement' analyzes fine , removing this Criteria has the
Query running just fine.

Anyone with experience with something similar?

[Non-text portions of this message have been removed]






---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

[Non-text portions of this message have been removed]
Vantage 6.10 -Developed a BAQ , trying to find PartDescription that contains a certain bit of text, using 'CONTAINS' Comparison Operator ( in this case, text = "shaft":
I have tried every syntax scenario I can think of , with and without * wildcard, ie:
'shaft*', "shaft*', 'shaft', "shaft" , the Query just locks up, even though the 'statement' analyzes fine , removing this Criteria has the Query running just fine.

Anyone with experience with something similar?


---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.

[Non-text portions of this message have been removed]
Bill, Try Matches in place of contains.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bill Jackson
Sent: 04 May 2007 14:20
To: vantage@yahoogroups.com
Subject: [Vantage] B.A.Query-Using CONTAINS Comparison



Vantage 6.10 -Developed a BAQ , trying to find PartDescription that
contains a certain bit of text, using 'CONTAINS' Comparison Operator (
in this case, text = "shaft":
I have tried every syntax scenario I can think of , with and without *
wildcard, ie:
'shaft*', "shaft*', 'shaft', "shaft" , the Query just locks up, even
though the 'statement' analyzes fine , removing this Criteria has the
Query running just fine.

Anyone with experience with something similar?








[Non-text portions of this message have been removed]