Hi I have a table, which contains fields like:
CREATE TABLE VAREFRVSTR_DETAIL ( V509INDEX VARCHAR( 30) DEFAULT '' COLLATE NONE, ANTALSTK NUMERIC( 18, 2) DEFAULT 0, BEH_KOSTPRIS NUMERIC( 18, 2) DEFAULT 0, VEJETKOSTPRISSTK NUMERIC( 18, 2) DEFAULT 0, Doing this SQL: SELECT VAREFRVSTR_DETAIL.V509INDEX, VAREFRVSTR_DETAIL.ANTALSTK, VAREFRVSTR_DETAIL.VEJETKOSTPRISSTK, VAREFRVSTR_DETAIL.BEH_KOSTPRIS FROM VAREFRVSTR_DETAIL WHERE VAREFRVSTR_DETAIL.V509INDEX = '2509720021' Will return this: V509INDEX ANTALSTK VEJETKOSTPRISSTK BEH_KOSTPRIS ----------------------------------------------------------------------- 2509720021 1 INF INF 2509720021 0 263,17 0 2509720021 1 263,17 263,17 2509720021 1 263,17 263,17 2509720021 0 263,17 0 2509720021 0 263,17 0 2509720021 0 263,17 0 2509720021 0 263,17 0 2509720021 0 263,17 0 What does INF mean? How can I create SQL to limit by value INF? Michael
