Extract numbers

P

Pietro

Hi,
I have a field in my database where it's written "1d" or "12d" ecc..
I want to use an equation in a query to display the number included in this
field only,meaning another field where it's written "1" or "12"
how can i do this ?
 
P

Pat Hartman

KARL's solution is correct but it is a violation of first normal form to
store multiple attributes in a single column. You are better off splitting
this field into two columns if possible.
 
Top