Update problem

Results 1 to 2 of 2

Thread: Update problem

  1. #1
    Join Date
    Dec 1969

    Default Update problem

    I posted a message yesterday, but didnt explain my problem properly.<BR><BR>I am using Access, and I want to build a query in access (not using ASP&#039;s) to take out any apostrohes in a certain field.<BR><BR>I have the following code, which is the exact names of the table and fields.<BR><BR>Running the following code, I get a message "undefined function &#039;Replace in expression&#039;"<BR><BR>UPDATE [Temp-TableTEMP] SET [Temp-TableTEMP].CustomerCode = Replace([Temp-TableTEMP].[CustomerCode],"&#039;","");<BR>

  2. #2
    Join Date
    Dec 1969

    Default SQL doesn't use double quotes

    So:<BR><BR>UPDATE [Temp-TableTEMP] SET [Temp-TableTEMP].CustomerCode = Replace([Temp-TableTEMP].[CustomerCode],&#039;&#039;&#039;&#039;,&#039;&#039;);<BR><BR>sh ould work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts