predicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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]
 
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]

vassilis said:
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.
Click to expand...
Click to expand...
 
Back
Top