Re: Convert varchar to number field

2001-04-23 Thread Gerald Clark
Steve Werby wrote: Martin E. Koss [EMAIL PROTECTED] wrote: I started a table with a varchar filed of 11 characters for a column that would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc I wasn't sure if a 'number' field would work. Now I want to list the values in this column

Convert varchar to number field

2001-04-20 Thread Martin E. Koss
Hi, I started a table with a varchar filed of 11 characters for a column that would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc I wasn't sure if a 'number' field would work. Now I want to list the values in this column and they do not list numerically, for example: if we had 0.27; 0.6;

Re: Convert varchar to number field

2001-04-20 Thread Steve Werby
"Martin E. Koss" [EMAIL PROTECTED] wrote: I started a table with a varchar filed of 11 characters for a column that would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc I wasn't sure if a 'number' field would work. Now I want to list the values in this column and they do not list