----- Original Message -----
From: "Goldwyn" <[EMAIL PROTECTED]>
> I am trying to search a search string which could be a sub-string of a
> record's field value.
>
> eg my database contains 2 fields(only) - full name and full address.
> I want to search the database by first name or by city which is just a
part
> of the fields full name and full address.
Till you get a better answer; I am not an SQL programmer:
select * from table where address like '%elhi%'
will find Delhi, New Delhi, delhi, etc
% matches like a * in shell glob.
------------------------------------------------
The mailing list archives are available at
http://lists.linux-india.org/cgi-bin/wilma/linux-delhi
