kan ikke lige huske hvor jeg fandt det men:
if (place.SelectedIndex == 1)
sql += " And (zipcode between '0' AND '4999') ";
if (place.SelectedIndex == 2)
sql += " And (zipcode between '4999' AND '5999') ";
if (place.SelectedIndex == 3)
sql += " And (zipcode between '5999' AND '6999') ";
if (place.SelectedIndex == 4)
sql += " And (zipcode between '6999' AND '7999') ";
if (place.SelectedIndex == 5)
sql += " And (zipcode between '7999' AND '8999') ";
if (place.SelectedIndex == 6)
sql += " And (zipcode between '8999' AND '10000') ";
http://www.modeltypes.dk/default.aspx?m=searchModel <-- under område er disse listet.. det er dog ikke amter, men "områder"
Med venlig hilsen
/Jokke Jensen
www.jj-multimediedesign.dk