predicates

[Guest]

hello ppl
i was wondering if the LIKE can be used combined with a parameter, so the
query remains the same but only change the text im looking for into a memo
data field.
i have tried some but i didnt do anything so far.pls let me know if this is
possible.

 

[John Spencer]

Yes, Like can be used with parameters.

Find string anywhere in field:
Like "*" & [Find What] & "*"

Find string at start of field:
Like [Find What] & "*"

Find string at end of field:
Like "*" & [Find What]

Find match (you are responsible for entering the wild cards)
Like [Find What]

 

[Guest]

thanks!!!

Ο χÏήστης "John Spencer" έγγÏαψε:

Yes, Like can be used with parameters.

Find string anywhere in field:
Like "*" & [Find What] & "*"

Find string at start of field:
Like [Find What] & "*"

Find string at end of field:
Like "*" & [Find What]

Find match (you are responsible for entering the wild cards)
Like [Find What]

hello ppl
i was wondering if the LIKE can be used combined with a parameter, so the
query remains the same but only change the text im looking for into a memo
data field.
i have tried some but i didnt do anything so far.pls let me know if this
is
possible.