Thread: executing sql server function

> Hi all: I want to execute following sql server function in Management studio. ALTER FUNCTION [Develop_pricebook].[SplitWords](@text varchar(8000)) RETURNS @words TABLE (pos smallint primary key, value varchar(8000)) what will be syntax for it. I tried following but got error select dbo.[SplitWords] 'sdasdda,dfdsf' exec dbo.[SplitWords] 'sdasdda,dfdsf' select * from dbo.[SplitWords] 'sdasdda,dfdsf'

> You should use dbo for your objects and not "Develop_pricebook" Once you do, try it again select [dbo].[SplitWords] ('sdasdda,dfdsf')