Hi all, I have used a select query in oracle. I am extracting a column's data. The data are numbers stored in string format. I Can not change the datatype of column. The column's datatype is varchar and after extracting it i am casting it to NUMBER to use it. Compulsory to cast it to number to use it. Say i have to extract a number 2.2 It is stored in database as 2.2 ,but after casting it i get the result as 2,2 Now i want to get the data with a decimal point in it and the data has to be a number but not a string. i.e this is what i want the data to be like 2.2 with datatype number And this is what i am getting 2,2 after casting with datatype number I have used the function cast() for casting of data from varchar to number.