If you want to mimic VFP, it will be user defined scalar function or computed column.

If the function can be written using inline logic, then I suggest a computed persisted column.

Also, just to explain - you can call UDFs in a query, but you can not call stored procedure in a query

(Except for

insert into ...
exec mySP @Param1, @param2 ...
)

>You see, in order for my code to work equally for VFP and SQL Server and use SF Query I have to have the SQL Server "recognize" the call to MyDateFunc(). I will try to create a small stored procedure and see what kind of error I get (if any). Thank you.
>
>>I suggest avoid creating scalar UDFs (as they don't scale well) and try to incorporate the logic into the main query. If the query is too complex, it can be a stored procedure.
>>
>>User Defined Function (scalar) can be an option, but don't overuse it.
>>
>>Also, you can have computed column in SQL Server. It can be persisted and indexed. So, this is another possibility to consider.
>>
>>Also consider a view in SQL Server.
>>
>>>Hi,
>>>
>>>This one is a truly newbie question.
>>>
>>>I need to create either a stored procedure or a function to serve the following purpose:
>>>
>>>In my VFP application, in Stonefield SDT, a table has a user-defined field (e.g. MyDateFunc). This function passes two field values, Date1 and Date2. So in the SDT this field/function defined as
>>>

>>>MyDateFunc( Date1, Date2 )
>>>

>>>
>>>This function therefore is in my application database container. Then, using SF Query, I can use this field to query the database. For example, the query could be like this:
>>>

>>>select * from MyTable where MyDateFunc( Date1, Date2) > 3
>>>

>>>
>>>In my VFP application there is actually this function, MyDateFunc, that takes two dates as parameters and returns the difference.
>>>
>>>When using SQL server this fails. Obviously because SQL Server does not have function MyDateFunc.
>>>
>>>So my question is, in order for the SQL Select to work against SQL Server, should I create a function MyDateFunc in SQL server or a Stored Procedure MyDateFunc?
>>>
>>>TIA.