Xailer & OZ Software

Running the following query on the Customers table (from the Xailer SQLite
sample db) results in emty dataset:
SELECT * FROM customer WHERE state = 'ME'
However, when changing the WHERE clause to "WHERE state LIKE 'ME'" or "WHERE
state LIKE 'ME%'" the result set is NOT empty (as expected).
I also have a problem when using something like WHERE state <= "ME"
NO PROBLEM if the field is a numerical field.
Regards,
Stephan

I have downloaded another SQLite db manager from the web and experienced the
same problems. So it's NOT a Xailer issue, but a SQLite issue. Still wonder
if somebody has some ideas about this.
For example, how can I run a query like "SELECT * FROM customer WHERE name <
'M' "??
Regards,
Stephan
"Stephan Hennekens" <stephan.hennekens@wur.nl> wrote in message
news:[email=46d176ff@ozsrv2.ozlan.local...]46d176ff@ozsrv2.ozlan.local...[/email]
> Running the following query on the Customers table (from the Xailer SQLite
> sample db) results in emty dataset:
> SELECT * FROM customer WHERE state = 'ME'
>
> However, when changing the WHERE clause to "WHERE state LIKE 'ME'" or
> "WHERE state LIKE 'ME%'" the result set is NOT empty (as expected).
>
> I also have a problem when using something like WHERE state <= "ME"
>
> NO PROBLEM if the field is a numerical field.
>
> Regards,
> Stephan
>

I have downloaded another SQLite db manager from the web and experienced the
same problems. So it's NOT a Xailer issue, but a SQLite issue. Still wonder
if somebody has some ideas about this.
For example, how can I run a query like "SELECT * FROM customer WHERE name <
'M' "??
Regards,
Stephan
"Stephan Hennekens" <stephan.hennekens@wur.nl> wrote in message
news:[email=46d176ff@ozsrv2.ozlan.local...]46d176ff@ozsrv2.ozlan.local...[/email]
> Running the following query on the Customers table (from the Xailer SQLite
> sample db) results in emty dataset:
> SELECT * FROM customer WHERE state = 'ME'
>
> However, when changing the WHERE clause to "WHERE state LIKE 'ME'" or
> "WHERE state LIKE 'ME%'" the result set is NOT empty (as expected).
>
> I also have a problem when using something like WHERE state <= "ME"
>
> NO PROBLEM if the field is a numerical field.
>
> Regards,
> Stephan
>