>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