Results 1 to 2 of 2

Thread: Update query

  1. #1
    Join Date
    Feb 2002
    Posts
    7

    Unanswered: Update query

    Hi,

    I need to update a field in a table with data that looks like
    01/01/1900
    01/02/1900
    and so on

    I wish to update the "1900" part of the data to "2000".

    How can I go about this?

    Thanks,



    Red

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Field type

    What format is the data, text or date?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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