Thanks Brian for your assistance... > are there multiple rows where ItemLookupCode = '400102666669' ?
- actually it is a portion of the Name of a product (ex: New Orange Velcro Jacket) I need it to say: New Orange Velcro brand faster Jacket That type of thing... Many Thanks, Brian Gonzales Internet Operations [EMAIL PROTECTED] 503.223.5937 ext: 124 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Cummiskey Sent: Monday, January 30, 2006 1:15 PM To: [email protected] Subject: Re: [php-list] Does anybody know what an "ntext error" would be in MSSQL? pairodimesmma wrote: > I tried to run this MSSQL query: > ##UPDATE Item > SET ExtendedDescription = REPLACE > (ExtendedDescription, 'Velcro', 'VELCRO brand fasteners') > WHERE ItemLookupCode = '400102666669'## are there multiple rows where ItemLookupCode = '400102666669' ? if its just one, there's no need to run a replace function. simply run the update setting extendedDescription = 'your new name' Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
