SQL Test for uppercase(10,000)

Tim James tjames1 at bigpond.net.au
Wed Apr 16 22:59:13 CDT 2003


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

TIA

Tim James



More information about the Valentina mailing list