OK i workig 100%

thnks

a little question

how can i add more filed to update

like

----------------

@Fname[nvarchar](50),@fld1 [smalldatetime], @fld2[int],

-----------------------

i wont to learn the method

---------------------------

declare @na varchar(500), @sisi int, @mmh char(10)

set @sisi='2'

set @mmh='uuu'

select @na = @na + cast([na] as varchar) + ',' FROM [vsisi]

UPDATE a SET a.sisi = @sisi,a.mmh = @mmh

FROM Sn a INNER JOIN [vsisi] b ON b.na = a.na

--------------

thnks a lot

ilan