>>Hi.
>>Is there any syntax of a Select command that will higghlight mssing numbers.
>>I have a table which has a field which should be sequential and I want to highlight if there are any msiing numbers.
>>I can do this by writing a program but wondered if there was a way to do this using select synatax ?
>>Regards
>>Gerard
>
>
>

>CREATE CURSOR NUMBERS (FN I)
>FOR K=1 TO 100
>	INSERT INTO NUMBERS VALUES (RAND()*97+3)
>NEXT
>SELECT DISTINCT FN FROM NUMBERS INTO CURSOR NUMBERS
>
>* RETURN GAPS
>lowerBound = 1
>UpperBound = 100
>SELECT m.lowerBound	GapBegin;
>,		MIN(FN)-1	GapEnd;
>	FROM NUMBERS N;
>	HAVING MIN(FN)>m.lowerBound;
>UNION ALL;
>SELECT	N.FN+1	;
>	,	NVL((SELECT MIN(FN) FROM NUMBERS WHERE FN > N.FN ) - 1,m.UpperBound ) ;
>	FROM NUMBERS N;
>	WHERE NOT EXISTS(SELECT * FROM NUMBERS WHERE FN-1 = N.FN)
>

Fabio,

I just tried your code against a real world table with ~135000 records, 18MB on disk. It failed after 15 minutes with:

File c:\temp\00000o3t0017.tmp is too large.

?