Re: [sqlite] Capitalisation

2011-03-25 Thread Igor Tandetnik
J Trahair wrote: > Hi. I've noticed that SELECT statements are specific to the capitalisation of > the WHERE section. > > Suppose I have a Customers table with a CustomerCode field, and a value in > one of the records of TRA001, eg: > > CustomerCode

Re: [sqlite] Capitalisation

2011-03-25 Thread Mihai Militaru
On Fri, 25 Mar 2011 10:35:37 +0100 "J Trahair" wrote: > If the SELECT statement is SELECT * FROM Customers WHERE CustomerCode = > 'tra001' that is, with tra001 in lower case, SQLite *does not find the > record*. SELECT * FROM Customers WHERE CustomerCode LIKE

Re: [sqlite] Capitalisation

2011-03-25 Thread Oliver Peters
J Trahair writes: [...] > SELECT * FROM Customers WHERE CustomerCode = 'tra001' > that is, with tra001 in > lower case, SQLite *does not find the record*. [...] use LIKE (http://www.sqlite.org/lang_expr.html#like) SELECT * FROM Customers WHERE CustomerCode LIKE 'tra001'

Re: [sqlite] Capitalisation

2011-03-25 Thread Cory Nelson
On Fri, Mar 25, 2011 at 2:35 AM, J Trahair wrote: > Hi. I've noticed that SELECT statements are specific to the capitalisation of > the WHERE section. > > Suppose I have a Customers table with a CustomerCode field, and a value in > one of the records of TRA001,

[sqlite] Capitalisation

2011-03-25 Thread J Trahair
Hi. I've noticed that SELECT statements are specific to the capitalisation of the WHERE section. Suppose I have a Customers table with a CustomerCode field, and a value in one of the records of TRA001, eg: CustomerCode CustomerName TRA001 Trahair SMI001 Smith If the