Mudhalvan, A Way of Thought here ... Cany u do this with the ASCII Function... Not sure but still a Thought ... Cheers Ganesh R On Thu, 30 Sep 2004 15:34:21 +0900, Mudhalvan, Moovarkku <mmudhalvan@xxxxxxxxxxxxxxx> wrote: > Dear DBAs, > > One field of my table have english and non-english characters. > Is it possible to find the values only have non-english values.=20 > > For Example > Empname field of EMP table have 5 English Employees name > , 3 Japanese Employee name and 2 Korean Employee Name. > > I need to output likely=20 > English 5 > Japanese 3 > Korean 2 > > Thanks in Advance > Mudhalvan M.M > >