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
- posted
14 years ago
sql statment
Loading thread data ...
- Vote on answer
- posted
14 years ago
update item set description=replace(description,'"','') where description like '%"%'
- Vote on answer
- posted
13 years ago
- Vote on answer
- posted
13 years ago
very similar:
update item set itemlookupcode=replace(itemlookupcode,' ','') where itemlookupcode like '% %'
- Vote on answer
- posted
13 years ago
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:
- Vote on answer
- posted
13 years ago
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
- Vote on answer
- posted
13 years ago