triple '''?

how come? I dont use any inside the query. see above:

DECLARE cursor_join CURSOR FOR SELECT DISTINCT(@coluna) FROM Split2Table(@valor,@delimiter)

As i understand there's no need for a ''' here

I still don't...

aah now seems to call the proc. but it errors. i don't know why.

ALTER PROCEDURE procJoinColuna

@coluna varchar( 2000 ),

@valor varchar( 2000 ),

...

and those are the bad guys which doesnt work:

It will only work IF I remove the dynamic query and replace by a static declare cursor query.

-- SET @cr_sql = 'DECLARE...

now the join :

drop function JoinColuna;

CREATE FUNCTION JoinColuna( @coluna varchar( 2000 ), @valor varchar( 2000 ), @delimiter char( 1 ) )

RETURNS varchar( 2000 )

AS

BEGIN

DECLARE

boy i think we messed it all! i will start it over. let me show you the code!

drop function Split2Table

CREATE FUNCTION Split2Table( @input varchar( 8000 ), @delimiter char( 1...

the function can be used as a part of select, as it is working.

i have a field with N ids delimited by ;

these ids are from a single table,...

a procedure can receive params and return a value as the function can?

because after all i need to select the result of it from another query, like this:

(select dbo.JoinColuna( 'fieldname',...

just to kill your curiosity a litle brief of what i do:

in a table i get a value like this: '14;-1;11;'

( yeah, they didn't normalize the table

my boss just says 'solve it no matter how' hehehe

this is the solution more reasonable i found. I just want the column to be dynamic, because this is a...

ah. sorry. I forgot to mention that this is a query from a cursor

i expected this to work but wont

SET @cr_sql = 'DECLARE...

because I want to pass the column name to the function which varies so...well.. it leads me to a dynamic query