The major difference is that a UDF can be used in a select statement (or anywhere else a function can be used), where a sproc must return a resultset.<BR><BR>For example, if you created a UDF ...