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
    Evangelist
    • takashiEvangelist
    • 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,531
    Posts
    119,537
    Replies
    39,160
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    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.