...
ALTER FUNCTION [dbo].[GetDealType](@symbol NVARCHAR(50))
RETURNS NVARCHAR(50)
BEGIN
RETURN (SELECT TOP 1 d.Name FROM Instruments i JOIN DealTypes d on i.Type = http://d.Id d.id - Empowering identity building and community growth through DID. WHERE Symbol = @symbol)
END
...