Skip to Content
0
Former Member
Apr 08, 2009 at 03:26 PM

select statment - where clause

28 Views

Hello experts,

I want to write a select statment,

e.g.

select * from pa0001 where ename like '%Rahul%'.

so this stamemt will give me all DB rows in which ename contains Rahul but i also want rows those are having rahul or rAhul or raHul or RAhul or RAHul or RaHul like wise....

can u plz help me on this ??? 😔