Hello to all I believe i have seen the answer to this question before but can?t find it I need to remove " from my item description field on all items thanks in advance
sql statment
Apr 12, 2010
6 Replies
update item set description=replace(description,'"','') where description like '%"%'
very similar:
update item set itemlookupcode=replace(itemlookupcode,' ','') where itemlookupcode like '% %'
Thanks matt Now I?m going to take advantage of you LOL Can you give me a command to remove supplier from items that are no longer In the system (deleted suppliers)
"Matt Hurst" wrote:
It sounds like you have removed a supplier from you vendor list but now want to remove mention of that supplier from any item they used to provide. If so, try this command:
delete supplierlist from supplierlist left join supplier on supplierid=supplier.id where supplier.id is null
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required