RE: Pass-Through Query Prompting for ID#
  Home FAQ Contact Sign in
microsoft.public.access.queries only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... access.queries Profile…
 Up
RE: Pass-Through Query Prompting for ID#         


Author: Lynn Trapp
Date: Jan 28, 2010 21:07

The '%%' wildcard also works in SQL Server, although the OP's use of it is
suspect. I would think the LIKE operator is needed.

--
Lynn Trapp
MCP, MOS, MCAS

"Jerry Whittle" wrote:
> What system are you hitting? The wildcard %% works in Oracle, but * may be
> used for other databases.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager...
Show full article (1.19Kb)
1 Comment
RE: Pass-Through Query Prompting for ID#         


Author: IrishRed
Date: Jan 28, 2010 22:49

Yes, the query is actually where MemberID Like '1245%%' I just typed it
incorrectly. Thanks.
I will take a stab at implementing the VB code suggested by Stefan. Thanks
for the responses.

"Lynn Trapp" wrote:
> The '%%' wildcard also works in SQL Server, although the OP's use of it is
> suspect. I would think the LIKE operator is needed.
>
> --
> Lynn Trapp
> MCP, MOS, MCAS
>
>
> "Jerry Whittle" wrote...
Show full article (1.48Kb)
no comments