CODEWITHSUNDEEP
sqlsql-server-2005
kacalapy
kacalapy

Reputation: 10154

how to call a scalar UDF?

i have created the udf to strip HTML from sql fields from here: link text

i am trying to run an update on my table where the defects_from_oracle.Description field has html

my sql is:

update defects_from_oracle
set Description = udf_StripHTML(Description)

where did i go wrong? i get error:

'udf_StripHTML' is not a recognized built-in function name.

Upvotes: 1

Views: 739

Answers (1)

bernd_k
bernd_k

Reputation: 11966

you missed the dbo. prefex

update defects_from_oracle
set Description = dbo.udf_StripHTML(Description)

Upvotes: 3

Related Questions