help with wildcard

[Paul M]

Hi
I wish to make it so someone can select all(non
geographic) in Geographical location instead of only one
option if they wish.I have been informed that I need to
introduce a wild card. can anyone help
Thankyou

here is the SQL

SELECT Format([Amount_required],'Currency') AS
fmtAmount_required, Amount_required, Sponsorship_type,
Geographical_location, Short_description,Project_ID FROM
Results WHERE (Amount_required <= ::Amount_required::
AND Sponsorship_type LIKE '%::Sponsorship_type::%' And
Geographical_location LIKE '::Geographical_location::')

 

[Jim Buyens]

Howdy.

Change
LIKE '::Geographical_location::'
to
LIKE '%::Geographical_location::%'
as you did for the Sponsorship_type field.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Paul M]

Thanks Jim

-----Original Message-----
Howdy.

Change
LIKE '::Geographical_location::'
to
LIKE '%::Geographical_location::%'
as you did for the Sponsorship_type field.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
Hi
I wish to make it so someone can select all(non
geographic) in Geographical location instead of only one
option if they wish.I have been informed that I need to
introduce a wild card. can anyone help
Thankyou

here is the SQL

SELECT Format([Amount_required],'Currency') AS
fmtAmount_required, Amount_required, Sponsorship_type,
Geographical_location, Short_description,Project_ID FROM
Results WHERE (Amount_required <= ::Amount_required::
AND Sponsorship_type LIKE '%::Sponsorship_type::%' And
Geographical_location LIKE '::Geographical_location::')
.

.