SQL Test for uppercase(10,000)

[Ruslan Zasukhin]

on 4/16/03 3:59 PM, Tim James at tjames1 at bigpond.net.au wrote:

Hi Tim,

> I have tested the following sql statement in my application and also in
> ViSql
> I fails to retrieve the record that is present
> 
> Select * from stock where left(titleu,6) = '10,000'
> 
> titleu is a method of title =upper(title)
> titleu and title are indexed  by word

This explain what you see.

When you index by words, Valentina split 10,000 on 2 words.
So left() cannot find it.

IT looks you need 
1) or drop index by words
2) or use LIKE

> title is defined as a string of 40 chars
> 
> a record does exist  with title = '10,000 babies names'
> 
> Am I doing something wrong - clearly the same statement works correctly
> when an alpha such as
> 'APPLE' is specified.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------