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