Kevin,

There're 3 separate properties, one for each type of UDF.

AND (OBJECTPROPERTY(id, N'IsInlineFunction') = 1
  OR OBJECTPROPERTY(id, N'IsScalarFunction') = 1
  OR OBJECTPROPERTY(id, N'IsTableFunction') = 1)

-- or

AND xtype in (N'FN', N'IF', N'TF')

>Sergey, I have another question on this.
>
>I'm looking at the BOL for OBJECTPROPERTY(), and I don't see an argument for a function.
>
>How can I use this to check to see if a function exists?