Visakh,..Thanks for your prompt response. I am using one of the reporting tool. However it is not allowing me to parse the syntax 'Expression type is not compatiable with the object type'. However in DB it is working fine.
If i select the data type to char, then it is parsing.