>thanks friend
>very nice solution
I still prefer to use Stored Procedures.
What if after a time you want all records that have form_type = ['D']?
Create a new view?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.