[Asterisk-Users] OT : For the SQL gurus..

brez brez at srmix.com
Mon Nov 10 11:17:02 MST 2003


 > 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; 




More information about the asterisk-users mailing list