I tried to run this MSSQL query: ##UPDATE Item SET ExtendedDescription = REPLACE (ExtendedDescription, 'Velcro', 'VELCRO brand fasteners') WHERE ItemLookupCode = '400102666669'##
But it gave me this: ##An error occurred while executing query: Argument data type ntext is invalid for argument 1 of replace function.## My goal is to change a small portion of text within a field. This is for a poroduct inventory database so this field should contain standard character sets. Any thoughts? 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/
