>I am trying to write some equivalent functions on SQL-Server that are available in VFP. When creating a procedure, it requires you to identify the data type coming in.
>
>In an example of the IIF(exp, val1, val2) function of vfp, you never know what the data types would be for Val1 and Val2.
>
>Is there a way to do a procedure with an unknown data type being passed in?
>
>TIA

I don't think so. You could make the parameters all varchar(255) and do a conversion if needed when sent to SQL Server.
DLC