SQL Test for uppercase(10,000)

[Tim James]

Thanks Ruslan, that explains it well

I think my preferred solution is to filter out special characters on 
loading the data in that field

is it only comma that you treat as a word separator ??


TIA

Tim



On Thursday, April 17, 2003, at 04:02  AM, Ruslan Zasukhin wrote:

> 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
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>