>how is the easier way to detect double records?
>
>I have a table like this:
>
>StockID
>-------
>01001
>01002
>01003
>01001 => double
>01004
>01002 => double
>
>how can I detect those double records without a complicated code?
>
>thanks for the help.

In addition to Tore's solution you may want to check Eliminating duplicates in a table FAQ #8129