Hey every body, Thanks a lot..
My main problem was those '\0' characters present in long value.
But then i noticed TRIM Function which is used like this..
To convert Char(19) into bigint
CAST(TRIM(TRAILING '\0' FROM COLUMN) AS BIGINT)
I mean, i did it like this, it there any other method.
Before this, i did it like
CAST(COLUMN AS BIGINT)
which yeilded me a error as: [conversion error from string "0"]
so i was worried ....
Anyways...
Once again thanks to you all for the support.
Take Care