My issue is ,im not able to retrieve records from the database which have same
values in different case.For example (HMPRASANNA,HMPrasanna,hmprasanna,hmPrasanna)
Is there any function like ignorecase to retrieve records which may be in any
case.Please help me to solve my issue.
select * from youtable where upper(yourcolumn)='HMPRASANNA';
select * from youtable where lower(yourcolumn)='hmprasanna';
select * from youtable where yourcolumn ilike 'hmprasanna%';
I used the query "select * from youtable where yourcolumn ilike 'hmprasanna%';"
It solved my issue,Thank u very much for providing such a fast solution.
Ur response is very soon, i din't expect such a fast response.
Thank u Very much.....