Skip to main content
Question

Using Concat with 2 Wildcards in Join Statement

  • Aug 23, 2022 4:40 PM UTC
  • 2 replies
  • 48 views
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?

    2 replies

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

    Hi Fynn,

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

    It works for me.

    BR, Attila

    Level 4
    Forum|alt.badge.img+6
    • fynn.reind
    • Author
    • Level 4
    • Sep 8, 2022 7:21 AM UTC

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

    Community Code of ConductAccessibility statement