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

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

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; 1