Sql custom function call - tsql
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?
source to share