Posted by m.bohse on 04/12/06 12:22

If your prefix is always "CON_" then this should work

SELECT Replace(country, 'CON_',''), COUNT(Replace(country, 'CON_',''))
from myTable
Group by Replace(country, 'CON_','')

Markus

• Next in forum: Re: Killing the process automatically
• Prev in forum: Re: Killing the process automatically
• Thread view: Re: "group by" by excluding prefix

[Reply to this message]