Hi,

I'm writing one pl/sql package. One of my function inside package is
getdata(servername).

My requierement now is not check if the servername has a 'CN' charaacter inside it. That means if servername is appcn01 then it should tell me yes it's the server and if something like appprn02 then no it's not.
Can anybody let me know how to write this.

Thanks in advance.