Re: GROUP BY

In article <9i8O6.591$_ub.180023808_at_news.telia.no>, inger ruud <iru_at_provida.no> writes:
>Hi!
>
>I would like to group my query by part of a field.
>
>Ex.
>
>25000000497670000000000
>27600000450947000000000
>57800000491818000000002
>57800000492500000000000
>
>I want to group by the 6 first characters.
>
>
>HELP!
>
>

Try "group by substr(colname,1,6) "

• MArk D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net