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

hope you understand.
The result is there in SQL. But while running in perl it not showing result must be some special charcter issue.
I tried various methods but not able to get the answer. As of now i have changed the query and splitting done in script.
Thanks
Srinivasan