I want to create a function to format a phone number. This is what I have but it says I have a syntax error. Anyone have any suggestions???

Thanks in advance!

CREATE FUNCTION FormatPhone (@phone CHAR(10))

RETURNS NVARCHAR(13)
AS
BEGIN
DECLARE
@number CHAR(14)
SELECT
if @number = 7 then
set @number = RIGHT(LEFT(@phone,3) + '-' + RIGHT(@phone,4)) RETURN @number END

elseif @number = 10 then
set @number = ('(' + LEFT(@phone,3) + ') ' + RIGHT(LEFT(@phone,6),3) + '-' + RIGHT(@phone,4)) RETURN @number END
end if

why dont you try something like this

let numchars = length(phone)

if numchars = 10 then
let scratch = "(",phone[1,3],")","-",phone[4,6],"-",phone[7,10]
end if

and the same thing for 7 numbers

Hope this hels

Cheers

Artem