Search results

  1. G

    Upper Case

    Any ideas how to Capitalise data in a table.
  2. G

    Merge Tables

    I have database A & database B, which is a copy of the first. I have made some changes to database B but need to merge one table back into the original database. Any ideas. Thanks.
  3. G

    Split a name filed.

    Hello there. I Have a Forename & Surname field. I want to be able to split the the Forename field into Forename & Surname. Any ideas.
  4. G

    Remove Duplicate Records

    Can anyone suggest a way to remove duplicate records. I've come up with this: SELECT *, count(*) cnt FROM tableName GROUP BY fieldname1, fieldname2, .... HAVING cnt > 1 But this does not fully resolve my problem. Thanks.
  5. G

    Update Query

    Can anyone help me. Attempting to run an update query to strip out some information from a table. Basically I want to remove the Tél : information & leave just the telephone number Tél : (+41 22) 718 10 00 Any ideas. Thanks.
Back
Top Bottom