[V4MD2] more LIMIT problems

[Ruslan Zasukhin]

On 6/14/05 1:19 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

> when using LIMIT:
> 
> "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '2%' LIMIT 0,23"
> properly returns 1366 records
> 
> "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '1%' LIMIT 0,23"
> should return 2972 records but returns 0
> 
> "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '3%' LIMIT 0,23"
> should return 48 records but returns 0
> 
> how is it possible that seaching for "starting with 2" works perfectly
> but 1 or 3 doesn't work?

May be send your database to Ivan's email for quick test.

Actually I wonder, why 1336 is correct, if LIMIT is 23 ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]