On Aug 6, 3:57 am, Kiran <[EMAIL PROTECTED]> wrote: > and if I query on 98456 the result must be 98456, > However if I query on 98455 the result must be 9845 > and If I query 9849 the result must be 984
SELECT MAX(t1) FROM t1 WHERE '9849' LIKE t1 || '%'; ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
