If you want to retrieve all the pictures to a single column, you can use similar syntax:

declare @table1 as table (

ProductId int

,SKU varchar(10)

,[Description] varchar(50)

)

insert into @table1

...

The way you have described, it seems like a simple join would give you the desired result. But if you could explain bit clearly it'll be possible to answer your...

Hi,

Isn't there a function called 'str_replace()' in SyBase, for text replacement functionality ??

--Manjuke

http://www.manjuke.com