[V4MD2] more LIMIT problems

Heinrich Ruoff heinrichruoff at gmail.com
Tue Jun 14 12:19:35 CDT 2005


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?

Heinrich

V4MD 2.0.4 fc5
Director MX 2004 10.1
Windows XP SP2


More information about the Valentina-beta mailing list