VException Information

[Ruslan Zasukhin]

On 4/18/06 3:52 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

> What I need now is to figure out why it doesn't like my "LIKE" call....
> 
> SELECT recID, * FROM QandAs WHERE qnda_area LIKE '%Test%'
> 
> It doesn't find any of the several records with "Test" or "Testing"
> in the qnda_area field of the QandAs table.

Empty result?
 
> If I change "LIKE" to "=" and drop the "%", it finds those with "Test".

I have made simple test db here

        select * from rr where ggg LIKE '%Test%'

It works fine here.


If that field is indexed, try reindex it

-- 
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]