[WEB4LIB] SQL database problem

[Stephen, Mathew]

Try adding "%" before and after the keyword your searching for.
for example;

SQL = "SELECT * "
SQL = SQL & "FROM table "
SQL = SQL & "WHERE field "
SQL = SQL & "LIKE '%" & sKeyword & "%' "



-----Original Message-----
From: Ian Winship [mailto:ian.winship at unn.ac.uk]
Sent: Thursday, April 13, 2000 10:46 AM
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 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.webjunction.org/wjlists/web4lib/attachments/20000413/75e3cbe8/attachment.htm