sqlstmt beginning with

[John]

Hi folks

I have an online form that currently shows all the courses from an Access
table called Courses - I would like to be able to limit the courses it shows
to different headings, e.g. as per below:

sqlstmt = "SELECT DISTINCT Course FROM Courses WHERE Course ='Management
Development'"

However, I would like to know what I need to type to show courses beginning
with e.g. Management rather than equalling e.g. Management as I have several
courses beginning with Management I would like them to be able to select from
- and exclude the other courses beginning with other names.

Many thanks,
John

 

[Kathleen Anderson [MVP - FrontPage]]

Using the Begins With comparison:

..If you choose Use this search form field, the SQL statement looks like
this:
SELECT * FROM Categories WHERE (CategoryName LIKE '::CategoryName::%')

..If you manually enter the Value, the SQL statement looks like this:
SELECT * FROM Categories WHERE (CategoryName LIKE 'text string%')


You may want to add this page to your favorites:
http://support.microsoft.com/kb/306430

 

[p c]

That was helpful. I never used FP's db wizard. I wrote my own connection
srings and code manually. And now I see that I am better off--I don't
need FP's layure for dealing with SQLs.

...PC