Skip to main content
  • EN

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!

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

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

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


Community Stats

31,798
Posts
120,793
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie 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.