Skip to main content
R
rollerskatie
Inspiring
April 20, 2007
Answered

CONCAT is undefined function

  • April 20, 2007
  • 3 replies
  • 538 views
I'm doing the following query (Access db), but its throwing an error, is there an alternative to CONCAT?

    This topic has been closed for replies.
    Correct answer rollerskatie
    SELECT Job_ads.*, Job_ads.ID & '|' & Job_ads.image & '|' & Job_ads.Alt
    AS Jobsadstr

    (the above code did it)

    Thanks both for your help.

    katie

    3 replies

    R
    rollerskatieAuthorCorrect answer
    Inspiring
    April 21, 2007
    SELECT Job_ads.*, Job_ads.ID & '|' & Job_ads.image & '|' & Job_ads.Alt
    AS Jobsadstr

    (the above code did it)

    Thanks both for your help.

    katie
    P
    paross1
    Participating Frequently
    April 20, 2007
    How about +?

    SELECT Job_Ads.*, Job_Ads.ID + '|' + Job_Ads.image + '|' + Job_Ads.Alt AS Jobadstr

    <EDIT: Ugh! That's right, Access uses the ampersand. Sorry!>

    Phil
    T
    tzimmerman
    Participating Frequently
    April 20, 2007
    Not sure if this is what you're looking for, but see http://www.techonthenet.com/access/functions/string/concat.php.

    HTH

    Ted Zimmerman
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices