I need to load the PictureName in the Item table with the ItemLookupCode and .jpg
example:
ItemLookupCode
00000001
I would like PictureName to be
0000001.jpg
thanks Barry
Sql to enter PictureName
May 28, 2008
2 Replies
00000001
0000001.jpg
Barry, This should work for you to updated all items in the database. Please perform a backup before ever executing a script against your database though.
UPDATE [Item] SET [PictureName] = [ItemLookupCode] + '.jpg'
Thanks Ryan Worked GREAT!!!! I was using the wrong bracket
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required