On 3/28/07, Lloyd K L <[EMAIL PROTECTED]> wrote:
Hi,
My table contains a text field called Name. Let the data be
Name
-------
Abc
abcd
AB
cab
def
I want to selcct all the rows which contains the term ab (not case
sensitive). How can I do this?
SELECT name FROM table WHERE Lower(name) LIKE '%ab%'l
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
