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

[Michael Bielicki]

Just as a tip you could do that with regex functions as well, omitting the 
quite costly length functions ..

On Monday 10 November 2003 1:11 pm, Reinhard Max wrote:
> On Mon, 10 Nov 2003 at 12:33, Reinhard Max wrote:
> >  SELECT DISTINCT *,length(code)
> >  FROM a
> >  WHERE '00442085673456' LIKE (code || '%')
> >  ORDER length(code) DESC;
>
>         ^
>         BY
>
> Oops, that one got lost when I re-formatted the query.
>
> cu
> 	Reinhard
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Michael Bielicki
Managing Director
TAAN Consultants Ltd
http://www.global-gateway.net/

--------------------------------------------------------------------------

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately delete it from your system and
notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient.

Any opinions expressed in this message are those of the individual sender.