I need to isolate those records containing numbers from a field with character string (it's a descriptive field). For example the string might be as follows:
"A residential development of 12 no. two storey dwellings comprising 10 no. 4 bedroom semi-detached houses and 2 no. detached 3 bedroom houses all with associated on-curtilage parking."
The numbers can occur anywhere in the string so I can't set
Right$ parameters. Anyone any ideas?