Skip to main content
Question

Using Concat with 2 Wildcards in Join Statement

  • August 23, 2022
  • 2 replies
  • 1 view
F
Level 4
Forum|alt.badge.img+6

Everytime i try to use the following query i get an eror message. It looks like this type of query with "LIKE", "CONCAT" and 2 wildcards is not allowed. Is there any possible solution?

1 Attachments

    2 replies

    attila.cserv11
    Level 3
    Forum|alt.badge.img+14

    Hi Fynn,

    try using || instead of concat(): ... LIKE '%'||"ActivityMapping_xlsx_Mapping"."BEZEICHNUNG"||'%'

    It works for me.

    BR, Attila

    F
    Level 4
    Forum|alt.badge.img+6
    • fynn.reind
    • Author
    • Level 4
    • September 8, 2022

    Thanks Attila for your answer. It worked this way :D

    Community Code of ConductAccessibility statement