predicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vassilis - 30 Nov 2005 14:28 GMT

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.

Reply to this Message

John Spencer - 30 Nov 2005 14:55 GMT

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
[quoted text clipped - 3 lines]
> is
> possible.

Reply to this Message

vassilis - 30 Nov 2005 22:07 GMT

thanks!!!

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

> Yes, Like can be used with parameters.
>
[quoted text clipped - 17 lines]
> > is
> > possible.

Reply to this Message