---

SQL = "SELECT sid, hold, hv, uv, (hv+uv) AS point FROM Stillinger ORDER BY
point"

Conn.Execute(SQL)
Set RS = conn.execute( SQL )

DO WHILE NOT RS.EOF
Response.Write RS("hold") & " - " RS("point")
RS.MoveNext
LOOP

Den skulle vise stillingen sorteret efter sumen af felterne "hv" og "uv" men
der vises ingen og heller ingen fejlmeddelse...


/Magnus

---

> SQL = "SELECT sid, hold, hv, uv, (hv+uv) AS point FROM Stillinger ORDER BY
> point"

Prøv: ORDER BY (hv+uv)

- den forstår nok ikke at du hentyder til et alias.

Rune