Sql custom function call - tsql

Question

I am doing the following:

    Insert into table1 
   (Phone#) values @Phone

There is a special function that will format the phone number. It takes a phone number as input and returns a formatted version.

I've tried the following, but I'm not sure if it won't work:

    Insert into table1 
   (Phone#) values fn_phone(@Phone)

It says fn_phone is not a recognized built-in function name. Am I doing something wrong, what am I calling fn_phone?

+3

sql tsql

Nate pet 21 Mar 12 at 19:19

source to share

3 answers

try:

Insert into table1 (Phone#) 
SELECT dbo.fn_phone(@Phone) (or whatever schema your function is in)

+1

Taryn 21 Mar 12 at 19:21

source to share

Assuming the function belongs to the "dbo" schema:

    Insert into table1 
   (Phone#) values (dbo.fn_phone(@Phone))

0

Moe sisko 22 Mar 12 at 6:20 am

source to share

Andrey Gurinov · Accepted Answer · 2012-03-21T19:21:50+0000

Use two part name when you call UDF

Try the following:

Insert into table1  
   (Phone#) select dbo.fn_phone(@Phone)