| Subject | Firebird, SQL Dialect 1 and NUMERIC(18,2) |
|---|---|
| Author | |
| Post date | 2013-11-25T10:54:16Z |
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