using like with field names

[TheShabz]

Hey all,



So apparently the "like" operator only seems to enjoy playing with strings.

i'm trying to get something to the effect of:
WHERE tbl1.field1 like *tbl2.field2*

help is appreciated.

[ajetrumpet]

what's the question shabz? what output are you looking for?

here's a quick tutorial:

LIKE "*" & [FIELD] & "*" will yield this: hello world - if the [field] = "llo" OR "world" OR "hello" OR "o wo"

LIKE *[FIELD] will yield this: hello world - if the [field] = "o world" OR " world"

make sense? (not sure about the second, didn't test it)

[TheShabz]

confusion on the part where i'm trying to get
WHERE tbl1.field1 like *tbl2.field2*

it seems as though the like operator doesnt take field names, only strings. i've tried different concatenations (ex. "*" & tbl.field &"*") but it is still not doing giving me results.

how do i get it to work?

[ajetrumpet]

(ex. "*" & tbl.field &"*") ]

that should work fine shabz. It works for me.

but look at what you wrote. the last & and "*" are too close. NO SPACE. that'll throw syntax error or no output.

I don't think you can do this: [table field]* (I tested it) , but you can do it your way.

[TheShabz]

of course. my coworker decided to play a gag on me and empty the reference table. no wonder i wasnt getting any results. revenge shall be mine.