Dear list,
Second problem in two days, so here goes.....
I have a character column, although some of the records have numbers in them. How do I go about just selecting those records with a number in the text?
My records look something like this:
leak on 4in main
burst main
burst 10 inch
In other words, the numbers do not always appear in the same place. So how can I just select those records with values in using SQL?
Many thanks in advance,
Tom
ps Enjoy the weekend and England's victory over our northern neighbours!!!!