>is is possible to send variant type of variable to SQL server SP.
>i.e. like VFP an integer, character or date is passed as parameter to same procedure to same parameter.
>Rajesh
Check SQL_VARIANT data type in BOL.
I have only 2005 installed here and can't tell you how reliable it is in SQL Server 2000.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.