"Like" Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 13 Sep 2007 14:48 GMT

Is there a simple way to do a "like" query in IP 2003?

The user wants to just type in the first 3 characters of a field and return
all those that start with "ABC"

Reply to this Message

S.Y.M. Wong-A-Ton - 14 Sep 2007 08:42 GMT

Hey Art! Long time no see! There is no easy way to do this; you will have to
write code. I did something similar with numbers in this article
http://enterprise-solutions.swits.net/infopath2003/query-access-database-list-nu
mbers.htm ; you could alter it to use a "like".
---
S.Y.M. Wong-A-Ton

> Is there a simple way to do a "like" query in IP 2003?
>
> The user wants to just type in the first 3 characters of a field and return
> all those that start with "ABC"

Reply to this Message

Art - 17 Sep 2007 14:16 GMT

Yes it has been a long time. Have to brush off my IP skills to do some more
forms

Actually, rather than going the code route, I just created a SQL view of my
table and added a new column of just the left 3 so I can search that way and
can bypass the %like% issue.

> Hey Art! Long time no see! There is no easy way to do this; you will have
> to
[quoted text clipped - 9 lines]
>> return
>> all those that start with "ABC"

Reply to this Message

S.Y.M. Wong-A-Ton - 18 Sep 2007 01:50 GMT

That one did not occur to me; thanks for the tip.
---
S.Y.M. Wong-A-Ton

> Yes it has been a long time. Have to brush off my IP skills to do some more
> forms
[quoted text clipped - 16 lines]
> >> return
> >> all those that start with "ABC"

Reply to this Message