>Hi
>
>How can I index\retrieve the lines with empty dates.
>
>For example:
>User need to confirm each line and the confim date must to be documented.
>I can put two columns, one for confirm (logical type or charcter (1)) and one for confirmdate, but I can put only confirmdate and if the date empty its means hat line not confirmed.
>Now I want to get all the lines that not conirmed by index.
>
>Help please
>
>Thanks

select * from myTable where myDate = {}

PS: I wouldn't create an index that specifically filters empty dates (using for clause).

Cetin