Skip to main content
Solved

Inline Querier Wildcard Matching

dmerrick
Contributor
Forum|alt.badge.img+1

Hi,

I am trying to match a numeric string in one field with what I have in another string field.

I want to compare what I have in the [ASBUILT_NUMBER] field with the [MAP_LABEL] field but I am unable to get the Inline Query wildcard expression to work.

I have tried many different iterations of

WHERE MAP_LABEL LIKE '%ASBUILT_NUMBER%'

or where @VALUE(ASBUILT_NUMBER) or inserting the wildcards and single quotattions into the field beforehand so I can compare the value to no success.

I know it works for static comparisons (MAP_LABEL LIKE '%963%') but I have not found success otherwise.

THANKS!

Best answer by takashi

You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 
View original
    Did this help you find an answer to your question?

    2 replies

    takashi
    Influencer
    • takashiInfluencer
    • Best Answer
    • July 5, 2019

    You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

    WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 
    dmerrick
    Contributor
    Forum|alt.badge.img+1
    • dmerrickContributor
    • Author
    • Contributor
    • July 5, 2019
    takashi wrote:

    You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

    WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 

    Thank you!

    Reply


    Helpful Members This Week

    Community Stats

    31,365
    Posts
    118,964
    Replies
    38,997
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.