I use UDF in my stored procedure:

CREATE PROC [dbo].[alg_mainSP] AS SELECT P1 * P1 AS [COL1], P1 * P1 AS [COL2], P1 * [u]dbo.do1_g ( S1 ) AS [COL3]</u> FROM testowa;

P1 and S1 are columns of course.

and some of Udf have "_" char in his name (like do_1g UDF in COL3) and i think this causes this error how to solve that problem ?

thanx for help

check the value in the UDF. If it contains characters, return 0.

i dont know if u understand me...:)
i have _ char in UDF name and i wonder if that causes problem with executing SP which uses this UDF ...

What is the error you are getting