Hi,
I need to convert a text field into a number in order to perform calculation with it. However the data in the field has characters in like this:
24 hrs
3456 hrs
48 hrs
etc.
Is there any way of writing a query which removes the 'hrs' from every record ?