Hey Jef,

Investing in this product should not be about the title, but more about the knowledge and skill acquired from studying and using the product.

By the way the MS new...

thx a lot steve.....

Loner or anyone you can have a look at the diagram for an idea of what i'm trying to design.

my prob with it is that i don't know...

did you post an image?

darn.....lol

thx lot man

Ok it worked thx alot again, however i noticed a lot blank spaces seperating each variables.

ex>> apple       ,cheese

       peach       ,bread

how can i rid these blank spaces?

ok thx man

datatypes for columns are as follows:

KPAIDS_NO char(10)

Date_Seen datetime

ARV int

i'm trying the following

use KPaids

go

drop function dbo.fn_GetARVList

go

CREATE FUNCTION dbo.fn_GetARVList

        (

    @KP char(10)

        ,@DS datetime

        )

RETURNS SQL_variant

AS

BEGIN

    DECLARE @buffer SQL_variant

    SELECT

                @buffer = IsNull(@buffer +...

Just tried that method, but still not gettin the result

any other suggestion please?