Replace and Update

MSAccess linking to Oracle 8 tables with Microsoft ODBC for Oracle
driver

I need to change the email address of all users because our domain has
changed. Is there a way to do this with SQL and not an Edit Replace
from Access?

SELECT REPLACE ('domainOld.com', 'domainOld.com',
'domainNew.com') FROM User_Table

This query returns the correct information. How could I write an UDPATE
query to do the same thing ?

Thanks for your time.

Dig

.

Relevant Pages

  • Oracle parameter problem with OraOLEDB driver
    ... both Oracle and SQL Server. ... I am using this driver rather than the ... I have a query which contains parameters, one of which is an integer. ... query has its datasource value set to a datasource as it is the detail part ...
    (borland.public.delphi.database.ado)
  • DTS error with Oracle 9.x
    ... I'm trying to get a DTS package to import data from Oracle into ... I can construct my query with no ... I've been using Oracle's 9.02.00.05 driver. ... Oracle driver 2.575.1117. ...
    (microsoft.public.sqlserver.dts)
  • Re: Connecting to Oracle via MS ODBC driver error
    ... from windows 2003 server using microsoft odbc for oracle drivers.... ... I had problems with the Microsoft ODBC driver when we switched from ... of the client, at least that is the case with the Oracle 10.2.0.1 ...
    (comp.databases.oracle.misc)
  • Missing "Microsoft ODBC for Oracle" in ODBC Aministrator Driver
    ... I try to use "Microsoft ODBC for Oracle" driver to connect a Oracle DB. ... Aministrator Driver? ...
    (microsoft.public.data.odbc)
  • Re: Missing "Microsoft ODBC for Oracle" in ODBC Aministrator Driver
    ... I try to use "Microsoft ODBC for Oracle" driver to connect a Oracle DB. ... But I found that "Microsoft ODBC for Oracle" is missing in ODBC ...
    (microsoft.public.data.odbc)