Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: If I could explain the problem..........

    In SQL database we need to concatenate 2 fields to display in one and turn them into an email address in the following format

    joe.bloggs@company.co.uk

    They are the following: forename & surname

    The expression will require a . to be added between the forename & surname and @company.co.uk at the end.

    Anyone help....... ?

  2. #2
    Join Date
    Sep 2003
    Location
    Brussel
    Posts
    52
    This should work:

    SELECT forename || '.' || surname || '@company.co.uk' AS [name]
    FROM [table]
    [WHERE ...];
    A good programmer is a LAZY programmer!

Posting Permissions

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