Using UDFs to avoid cursors

/*
Code to create and populate tables
*/
CREATE TABLE Contacts
(
  ContactID int IDENTITY PRIMARY KEY, 
  FirstName varchar(100),
  LastName varchar(100)
)

CREATE TABLE PhoneNumbers
(
  PhoneID int IDENTITY PRIMARY KEY,
  ContactID int,
  PhoneNumber varchar(50)
)

DECLARE @id int

INSERT INTO Contacts
VALUES ('John',  'Smith')

SELECT @id = @@IDENTITY

INSERT INTO PhoneNumbers
VALUES (@id, '111-222-3333')

INSERT INTO PhoneNumbers
VALUES (@id, '444-555-6666')

GO

/*
Code to create UDF for getting phone numbers
*/
CREATE FUNCTION GetPhones (@ContactID int)
RETURNS varchar(2000)

AS
BEGIN

DECLARE @phones varchar(2000)
SET @phones = ''

SELECT @phones = 
CASE @phones
   WHEN '' THEN ISNULL(PhoneNumber, '')
   ELSE @phones + ', ' + ISNULL(PhoneNumber, '')
END
FROM PhoneNumbers
WHERE ContactID = @ContactID

RETURN(@phones)

END

GO

/*
Code to execute function from SELECT statement
*/
SELECT FirstName, LastName, dbo.GetPhones(ContactID)
From Contacts