[WEB4LIB] SQL database problem

[Luis Domingues]

You can use
Select * from books where (title Like "*the word you want to search*")

Luis Filipe F. F. Domingues                   E-Mail: lfd at libri.ucp.pt
Biblioteca Universitária João Paulo II        Home Page:
http://www.libri.ucp.pt/
Universidade Católica Portuguesa              Tel: +351 21 7214019
Palma de Cima                                 Fax: +351 21 7214010
1600 Lisboa
Portugal

 -----Original Message-----
From: 	web4lib at webjunction.org [mailto:web4lib at webjunction.org]
On Behalf Of Ian Winship
Sent:	Quinta-feira, 13 de Abril de 2000 16:45
To:	Multiple recipients of list
Subject:	[WEB4LIB] SQL database problem

We are setting up a database of reading lists, but are having problems with
searching.

The database is in Access, searched by SQL from an .asp page. There is a
title field, but it seems possible to search only the complete title or the
first word (needs a wildcard).

How can we search for any word in the title field?

Thanks in advance.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ian Winship
Learning Resources, University of Northumbria at Newcastle
City Campus Library, Newcastle upon Tyne NE1 8ST, UK

                    ----------------
e-mail: ian.winship at unn.ac.uk
phone:  0191 227 4150      fax: 0191 227 4563
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~