Both @Jimhorn and @angelIII - I will not be able to modify existing Table which has thousands of records.
@Jimhorn, I can create a new table like temp_PlacedOrderdetails and create two different columns as Size and SizeUnit. But again, I need to take a lengthy permission as because database belongs to a Thirdparty software provider.
Anyways for me to fix it without changing the datatype or table schema
Guy Hengel [angelIII / a3]
> I will not be able to modify existing Table which has thousands of records.
even if the table is containing records, you can modify the data types ...
you may add a new column with the proper data type, update that column from the existing one, drop the old column, and rename the new column
though you can work out your queries without changing data types, you will just end up with many more problems ...
"size" column should be 2 columns, one containing the "unit" type, the other the actual size value. ...
chokka
ASKER
Table : PlacedOrderDetails , is loaded from a CSV file which has values SizeUnit (ie. 100 mg or 15 ml ) populated.
If i go with your decision, i have to create a new table such as temp_PlacedOrderDetails which export data from PlacedOrderDetails and split the value of Size Column to two different columns such as Size and Unit
@Jimhorn, I can create a new table like temp_PlacedOrderdetails and create two different columns as Size and SizeUnit. But again, I need to take a lengthy permission as because database belongs to a Thirdparty software provider.
Anyways for me to fix it without changing the datatype or table schema