[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