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
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
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'
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,
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
5 matches
Mail list logo