MySQL Forums
Forum List  »  Newbie

Re: Best match
Posted by: Ramalingam Chelliah
Date: September 01, 2004 10:22PM

Hi ,
Check if this helps you...

MIN(CHAR_LENGTH(TRIM(LEADING GroupId FROM '01554300'))
AND
TRIM(LEADING GroupId FROM '01554300') !='01554300')

Also GROUP THE TABLE by GROUPID

And for the converse part USE MAX(.....) instead of MIN(....)

Regards,
Ram.


We Learn the Most When we have to Invent

Options: ReplyQuote


Subject
Written By
Posted
August 31, 2004 04:22PM
September 01, 2004 10:36AM
September 01, 2004 02:36PM
Re: Best match
September 01, 2004 10:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.