Thank you for your assistance: > are you sure that ExtendedDescription is the correct field name?
Unfortunatley I tried this Query on a few different fields - very sure of their spelling and no luck. Thanks for the suggestion. Many Thanks, -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Sent: Monday, January 30, 2006 2:27 PM To: [email protected] Subject: Re: [php-list] Does anybody know what an "ntext error" would be in MSSQL? In message <[EMAIL PROTECTED]>, pairodimesmma <[EMAIL PROTECTED]> writes >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. This syntax works for me - are you sure that ExtendedDescription is the correct field name? UPDATE temp2 SET f02=REPLACE(f02, 'Oggle', 'Iggle Iggle Iggle') WHERE f01=2; -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com 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/
