PASS SQL FORMULA IN ACCESS (TEXT MINING)

Asked

Viewed 17 times

0

Good afternoon! I’m passing a sql formula for access

WHEN ((SA_P1_RESULT_VISITA LIKE '%VISITAD%')
                                         OR  (SA_P1_RESULT_VISITA LIKE '%FACHAD%')
                                         OR  (SA_P1_RESULT_VISITA LIKE '%INSTALA%')
                                         OR  (SA_P1_RESULT_VISITA LIKE '%ESTOQUE%')
THEN 1 ELSE 0
                                  END IN_TXT_MING_VISIT

In this case, I am looking for these files in the SA_P1_RESULT_VISITA field and returns 1 if you find the result and 0 if you do not find.. this in oracle. But I want to do the same in ACCESS, but I’m not getting, someone can give me a help?

sql oracle ms-access

  • This section you posted is missing one ). Try IIF((SA_P1_RESULT_VISITA LIKE '%VISITAD%') OR (SA_P1_RESULT_VISITA LIKE '%FACHAD%') OR (SA_P1_RESULT_VISITA LIKE '%INSTALA%') OR (SA_P1_RESULT_VISITA LIKE '%ESTOQUE%'), 1, 0).

  • When I use this formula returns me 0 even finding the word, the closest I got was using IIF(INSTR(SA_P1_RESULT_VISITA,"VISITAD")>0,1,0), but it is returning me -1 and I have to keep using this formula for all words ;\

  • Dude, I got it now, I found out that access uses "*" and not "%" kkkkkk

No answers

Browser other questions tagged sql oracle ms-access

You are not signed in. Login or sign up in order to post.