> SELECT *, length(code) > FROM a > WHERE code = '00442085673456' > OR code = '0044208567345' > OR code = '004420856734' > OR code = '00442085673' > OR code = '0044208567' > OR code = '004420856' > OR code = '00442085' > OR code = '0044208' > OR code = '004420' > OR code = '00442' > OR code = '0044' > ORDER BY length(code) DESC; >Again, the first row in the result set is the one you are after.
can be reduced to:
SELECT TOP 1 *, length(code)
FROM a
WHERE code LIKE '0044%'
ORDER BY length(code) DESC;
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
