I have table with some fields..i defined one field was char(35).But during stored that value less num of sting length.. i want get that record extract that data into another dataset.. but that string have with out spaces.. If u do not understand i given below for example.. i want extract data from that table to another dataset...
ID NAME ADDRESS CITY
12 RAM 23,WEST STREET, CHENNAI
11 KUM 23,WEST STREET ,NORTH CHENNAI
please help me... i used RTRIM but during extract that will be there in address and city.. address is char(35) .. in that table address and city have spaces.. in dataset i don't want space between address and city