Re: Pulling numbers out of a column for a query

2004-01-06 Thread Hal Vaughan
Thanks for the responses on this. I've gotten so used to using the ref materials I have on hand that, unfortunately, I forgot to check online manuals from time to time. (My measly sources had helped with what I needed until now and my best source, "MySQL Cookbook", is on loan to a friend.) I

Re: Pulling numbers out of a column for a query

2004-01-06 Thread Tobias Asplund
On Mon, 5 Jan 2004, Hal Vaughan wrote: > I've found an odd problem in queries. > > I have a lot of data regarding vehicle speeds in a survey. All the data is in > the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles > per hour in a 55 miles per hour zone. 80/55 means we

Re: Pulling numbers out of a column for a query

2004-01-06 Thread Michael Stassen
Hal Vaughan wrote: I've found an odd problem in queries. I have a lot of data regarding vehicle speeds in a survey. All the data is in the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles per hour in a 55 miles per hour zone. 80/55 means we have a serious speed demon

Pulling numbers out of a column for a query

2004-01-05 Thread Hal Vaughan
I've found an odd problem in queries. I have a lot of data regarding vehicle speeds in a survey. All the data is in the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles per hour in a 55 miles per hour zone. 80/55 means we have a serious speed demon, going 80 in a 55 z