RE: Problem selecting records in SQL using theSQL command DATE

[rob@xxxxxxxxx]

If they will not let you load free software then mimic it. 
A sample user defined function may be

STRSQL

CREATE FUNCTION
BEGIN DECLARE CHARNUMDATE CHAR ( 8 ) ; 
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN RETURN NULL ; 
END ; 
SET CHARNUMDATE = CHAR ( NUMDATE ) ; 
RETURN DATE ( SUBSTR ( CHARNUMDATE , 1 , 4 ) || '-' || SUBSTR ( 
CHARNUMDATE , 5 , 2 ) || '-' || SUBSTR ( CHARNUMDATE , 7 , 2 ) ) ; 
END 

Then you end up selecting the rows with a null return value to find the 
erroneous ones like Alan's example.

Rob Berendt