Dear Sir/Madam,
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.
Regards,
Prasanna.B
|
For instance,
select * from youtable where upper(yourcolumn)='HMPRASANNA';
select * from youtable where lower(yourcolumn)='hmprasanna';
select * from youtable where yourcolumn ilike 'hmprasanna%';
|
Dear Sir/Madam,
Really Great!!!!!!!!
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.....
Regards
Prasanna.B
|
Main
webmaster@hxtt.com