note SriniK Hi,<br/> Thanks for your replay.<br/> <br/>$name will be like "Christin". the Direct result in sql will be <code> phone_no Mail_ID +00 00 0000 0000 ********.*****@******.com </code> In that query the actual result will be +00 00 0000 0000$$********.*****@******.com$$$******, in that im splitting the required phone no and mail id using sub string in sql <br/> <br> hope you understand. <br/> The result is there in SQL. But while running in perl it not showing result must be some special charcter issue. <br/> I tried various methods but not able to get the answer. As of now i have changed the query and splitting done in script. <Br/> Thanks<Br/> Srinivasan 1008099 1008249