hi everyone,
i need help on a sql query.
consider a table weather containing a column city.
suppose i have two rows with data in the city column as 'new delhi' and
the second as 'new whatever'.
so to select one row with say 'new delhi' i would give the following sql
command
SELECT * FROM weather WHERE city = 'new delhi';
what is the query if i want to select all rows with 'new' as a pat of
the string in the city column? in this case both the above rows should
be returned
thanks
rahul.