Re: Convert SQL Server Compact data to MySQL

2012/04/05 02:15 -0700, sam I have data file written in SQL Server Compact.I need to Convert it to MySQL. Does anyone know how to do that? If it stores in CSV files, you can use that for the data, although to make MySQL read it, you hav to fiddle with it. The SQL, for tables &

Re: Convert SQL Server Compact data to MySQL

Unfortunately they don't have MySQL Migration Toolkit  for Ubuntu --- On Thu, 4/5/12, Pothanaboyina Trimurthy wrote: From: Pothanaboyina Trimurthy Subject: Re: Convert SQL Server Compact data to MySQL To: "sam" Date: Thursday, April 5, 2012, 4:56 AM hello sam you can convert

Re: Convert unix time to 12:00 AM of that same day

Hi Bryan, all! Bryan Cantwell wrote: > That's closer: > SELECT > UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); > Gives me 6:00 PM today... The Unix timestamp is UTC-based (old name: GMT). You don't write which timezone you are using, but your notation "6:00 PM" makes me assume you are

Re: Convert unix time to 12:00 AM of that same day

That's closer: SELECT UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); Gives me 6:00 PM today... On 03/01/2011 12:32 PM, Singer X.J. Wang wrote: SELECT unix_timestamp() + 86400 - (unix_timestamp() % 86400); -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Convert unix time to 12:00 AM of that same day

SELECT unix_timestamp() + 86400 + (unix_timestamp() % 86400); currently gives me 6:39 AM tomorrow SELECT UNIX_TIMESTAMP(DATE(FROM_UNIXTIME(1299003702))); actually gives me what I want, but seems really stupid way of getting something that is probably very simple On 03/01/2011 12:03 P

Re: Convert unix time to 12:00 AM of that same day

You could use: CONCAT(DATE_FORMAT(FROM_UNIXTIME(1298999201),'%Y-%m-%d'),' 12:00:00') JW On Tue, Mar 1, 2011 at 11:58 AM, Bryan Cantwell wrote: > It was of course a typo, and even with the correct number isn't the answer > > > On 03/01/2011 11:47 AM, Claudio Nanni wrote: > >> >> You can start by

Re: Convert unix time to 12:00 AM of that same day

It was of course a typo, and even with the correct number isn't the answer On 03/01/2011 11:47 AM, Claudio Nanni wrote: You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, "Bryan Cantwell" > wrote: > I'd asked before how to convert a unix timestamp

Re: Convert unix time to 12:00 AM of that same day

You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, "Bryan Cantwell" wrote: > I'd asked before how to convert a unix timestamp to the hour that it is > in (and got the perfect answer) : > 1298999201 = 3/1/2011 11:06:41 AM > (1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM > >

Re: convert week of the year into a date string

I did something similar to this recently. I ended up using the following select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) * 7) - 1) DAY) as mydate. This was in php and ahead of time I set $week as select week(curdate()). It could easily be extended with year. Phil On

Re: convert week of the year into a date string

Pintér Tibor wrote: Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of d

Re: convert week of the year into a date string

Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start of

Re: convert week of the year into a date string

Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start of the year) makedate(

Re: Convert Dbase file to mysql and enter data

Andrew, I have a dbase3 database that I would like to convert to mysql. A dBASE III "database" isn't a database but rather a single ASCII fixed-field-length data table with a binary header describing data layout. I think these are your main choices: (i) if you have an xbase product on hand

Re: convert duration(mediumint) to hours and minutes

this will format that value inline. select concat(floor(pr_id / 60),':',mod(pr_id,60)) AS mytime from ... If you are running 5.0+ you may want to push this down into a UDF - michael On 3/29/07, Reinhart Viane <[EMAIL PROTECTED]> wrote: Hello list, I have a table events in a database that has

Re: Convert hex to decimal?

On 11/6/06, Dušan Pavlica <[EMAIL PROTECTED]> wrote: > How would I convert > > 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? > conv('column_name', 16, 10) Thanks, that works! Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Convert hex to decimal?

Frederic Wenzel napsal(a): Hey, I have a table with a SMALLINT column that -- trough a mistake -- contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. HEX numbers). How would I convert 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? I tried my luck with UN

Re: Convert hex to decimal?

> I have a table with a SMALLINT column that -- trough a mistake -- > contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. > HEX numbers). > > How would I convert > > 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? > > I tried my luck with UNHEX and CAST but I

Re: convert help

Hello. > ERROR 1314 (0A000): PREPARE is not allowed in stored procedures PREPARE in the stored procedures should work in the latest release (5.0.18). David Godsey wrote: > Thank you. I tried this outside of the procedure and it works. However In > MYSQL 5 I get: > ERROR 1314 (0A000): PREPARE

Re: convert help

Thank you. I tried this outside of the procedure and it works. However In MYSQL 5 I get: ERROR 1314 (0A000): PREPARE is not allowed in stored procedures Is there a way without needing to use prepare? Any idea why CAST(fdata AS UNSIGNED) doesn't work? David Godsey > Hello. > > You can use this

Re: convert help

Hello. You can use this technique: drop procedure if exists test20; DELIMITER $$ create procedure test20() BEGIN DECLARE fdata BLOB; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE tmp_int BIGINT UNSIGNED; SELECT 0xAB

Re: convert varchar/char to integer

morten bjoernsvik <[EMAIL PROTECTED]> skrev: Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a perl-procedure.

Re: Convert Subquery - need to find max of a set

[EMAIL PROTECTED] wrote: "Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms

Re: Convert Subquery - need to find max of a set

"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: > I need to convert this query into one without a subquery: > > SELECT > r.selector_forms_results_max_points AS points, > r.selector_forms_results_description AS description, > FROM selector_forms_results AS r > WH

Re: convert varchar to char

Pooly wrote: Damnit ! Thanks for pointing it, I forgot these things. But it's a bit more subtle : If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR colu

Re: convert varchar to char

Yeah, for example the last statement ALTER, ..., ... is the only way sometimes to make things working. anyway, it's worth knowing it. 2005/8/13, Chris Elsworth <[EMAIL PROTECTED]>: > On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > > Damnit ! > > Thanks for pointing it, I forgot these

Re: convert varchar to char

On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > Damnit ! > Thanks for pointing it, I forgot these things. > But it's a bit more subtle : [snip] Bah, should have waited another 5 minutes before I bothered posting my last long-winded ramble ;) > ALTER TABLE sessions MODIFY id char(32) NOT

Re: convert varchar to char

On Sat, Aug 13, 2005 at 04:01:38PM +0100, Pooly wrote: > > ALTER TABLE sessions MODIFY ip char(8) NOT NULL DEFAULT '0'; > ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT ''; Hello, Since you have two varchar columns, I don't think there's any way to convert them both to char without dro

Re: convert varchar to char

Damnit ! Thanks for pointing it, I forgot these things. But it's a bit more subtle : If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than

Re: convert varchar to char

Pooly wrote: Hi, I try to convert a varchar to a char, but it doesn't seems to work. From the manual: "...all CHAR columns longer than three characters are changed to VARCHAR columns." http://dev.mysql.com/doc/mysql/en/silent-column-changes.html > -- Roger -- MySQL General Mailing List F

Re: Convert subquery

2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I actually had something similar to this at one point, but I never got it > working. Your query returned 148 rows, which I can tell you right away > can't be right since there are only 130 items in `page`. I believe the > problem is that it do

Re: Convert subquery

I actually had something similar to this at one point, but I never got it working. Your query returned 148 rows, which I can tell you right away can't be right since there are only 130 items in `page`. I believe the problem is that it doesn't take into account that a page may be a child page

Re: Convert subquery

Shawn, Thanks so much, this is exactly what I was looking for. I was having trouble getting the condition (page_links.page_id=6) in the right place. I had gotten as far as SELECT page.page_id, page_keyword FROM page LEFT JOIN page_links ON page.page_id=page_links.child_id WHERE page.page_id<>6

Re: Convert subquery

2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I am moving some code that was developed against MySQL 4.1 to a server > with 3.23, and I have one query that uses a subquery. I'm having a bear > of a time wrapping my mind around how to convert this. The original > query is this: > > SELECT

Re: Convert subquery

"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 05/17/2005 02:37:12 PM: > I am moving some code that was developed against MySQL 4.1 to a server > with 3.23, and I have one query that uses a subquery. I'm having a bear > of a time wrapping my mind around how to convert this. The original

Re: Convert historical dates from UTC

At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote: What do you mean by "historical"? Are we talking 20th century dates or something BCE? Dates that could be a couple of years old. - Mike Rykowski IT - Telecommunication and Network Services (847) 467-7335 [EMAIL PROTECTED] -- MySQL General Maili

Re: Convert historical dates from UTC

Mike Rykowski <[EMAIL PROTECTED]> wrote on 03/22/2005 11:12:41 AM: > Hello, > > I have historical dates in datetime format and they are in UTC. I'd like > to convert them to localtime. Can this be done with mysql 3.23.22? It > looks like 4.1 can handle this, but I won't be upgrading in a whi

Re: Convert to character set (upgrading from 4.0 to 4.1)

Hello. As said at: http://dev.mysql.com/doc/mysql/en/charset-conversion.html You should avoid trying to convert directly from latin1 to the real character set. If you have a backup, import a table from it. Check that your character_set_xxx variables have a corresponding values. See:

RE: Convert subselect query to pre-subselect query

Doh... Guess I spoke too soon. I get it now. I wasn't seeing a.CategoryID=b.ID =) > -Original Message- > select a.ID > from products a, categories b > where a.CategoryID=b.ID and (b.ID='21' OR b.ParentID='21') -- MySQL General Mailing List For list archives: http://lists.mysql.co

RE: Convert subselect query to pre-subselect query

--Original Message- > From: Remi Mikalsen [mailto:[EMAIL PROTECTED] > Sent: Friday, October 08, 2004 5:07 PM > To: [EMAIL PROTECTED] > Subject: Re: Convert subselect query to pre-subselect query > > Try this... > > select a.ID > from products a, categories b > where a.

Re: Convert subselect query to pre-subselect query

Try this... select a.ID from products a, categories b where a.CategoryID=b.ID and (b.ID='21' OR b.ParentID='21') The query is pretty straigthforward and I believe it's quite easy to understand. Hope this is what you wanted! A tip... only use left and right joins whenever you want what is on t

RE: convert

i have converted access to mysql easily using the sqlyog gui tool -Original Message- From: karl james [mailto:[EMAIL PROTECTED] Sent: Sunday, February 08, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: convert Hey guys, I was wondering if there is a converter for access databases to mysql

Re: Convert MS Access to MYSQL

On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote: There was some discussion in December of converting MS Access databases to Mysql and the DBManager program was recommended. I have recently converted access to mysql. I used access to import a CSV file and ensured all data was in

Re: Convert query from v4 syntax to v3

On 9 Jan 2004 at 15:33, Roger Baklund wrote: > * Rory McKinley > [...] > * Odhiambo Washington > >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > [...] > > I can't see what is throwing the syntax error..p'raps I am just > > being dense. > > "Note that INNER JOIN synta

Re: Convert query from v4 syntax to v3

* Rory McKinley [...] * Odhiambo Washington >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] > I can't see what is throwing the syntax error..p'raps I am just > being dense. "Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same i

Re: Convert query from v4 syntax to v3

On 9 Jan 2004 at 16:48, Odhiambo Washington wrote: > * Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote: > > On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > > > > > > > Hello, > > > > > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > > > > > > SELEC

Re: Convert query from v4 syntax to v3

* Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote: > On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > > > > Hello, > > > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > > > > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, > CONC

Re: Convert query from v4 syntax to v3

On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: > > Hello, > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x: > > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (do

RE: Convert MS Access to MySql

Hi Arthur, Dbtools is a free product and it will do the conversion for you. http://www.dbtools.com.br/EN/index.php We have had success converting from MSAccess to MySQL in the past with it. Regards, Matt -Original Message- From: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Sent: Sunday

Re: Convert MS Access to MySql

Arthur On converting data from MS Access. I've done this several times myself, and found the easiest way is to: 1. Create your mySQL database tables 2. Define a DSN (ODBC Connection) from your workstation to the mySQL database 3. Link the mySQL tables into your MS Access database 4. Copy the conte

Re: Convert MS Access to MySql

I'm new to MySql as well but the "LOAD DATA" statement is probably what your looking for. It's a bulk loader and dumps the data from a flat file into a designated table for you. You could easily automate this by writing a simple perl script(probably php also but im not to familiar with that langua

Re: convert dynamic page to html page

On Thursday 18 December 2003 17:46, Paul Godard wrote: > Hi > > I build a online catalog linked to mysql db. > > Now my client wants the site on a cdrom. > > What is the fastest way to convert the product pages into static html > format? -- wget --mirror ? -- MySQL General Mailing List For li

Re: Convert Foxpro database to Mysql

On Saturday, October 4, 2003, at 11:05 AM, Dwi Suharto Panese wrote: i want to convert the existing foxpro database into mysql database. Any idea? Sure, I've done it a lot. What exactly do you need to know? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.c

Re: convert grant tables to innodb?

At 18:06 -0700 9/29/03, Rusty Wright wrote: Is it possible, desirable, etc. to convert the mysql grant, system, etc. tables to innodb? I.e., use mysql; alter table columns_priv type = innodb; alter table db type = innodb; alter table func type = innodb; alter table host type = innodb; alter table

Re: convert grant tables to innodb?

On Mon, Sep 29, 2003 at 06:06:56PM -0700, Rusty Wright wrote: > Is it possible, desirable, etc. to convert the mysql grant, system, > etc. tables to innodb? I.e., > > use mysql; > alter table columns_priv type = innodb; > alter table db type = innodb; > alter table func type = innodb; > alter tab

RE: Convert date from .txt file

Blanchard [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14:08 To: Andre Winarko; [EMAIL PROTECTED] Subject: RE: Convert date from .txt file [snip] How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot

RE: Convert date from .txt file

[snip] How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot do the conversion "on-the-fly". You could use a scripting language (sed, awk,etc.) to read and convert the dates. HTH! -- MySQL General Mailing List

Re: convert to mysql function

On Wed, Feb 26, 2003 at 12:32:57AM -0800, DiAnNe iRiS aLeRta wrote: > i have made a simulation for horizontal aggregation in C++ but had a > hard time converting it to MySQL codes for me to create a function for > MySQL? > > how can i convert my C++ code inorder for it to be accepted and run in >

RE: Convert dates for import into Mysql

Thanks to Peter's hint here's an example of how I'll be doing it using PHP: David > -Original Message- > From: Peter Engström [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 12:18 PM > To: David Yee > Cc: [EMAIL PROTECTED] > Subject:

RE: Convert dates for import into Mysql

nal Message- > From: Peter Engström [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 12:18 PM > To: David Yee > Cc: [EMAIL PROTECTED] > Subject: Re: Convert dates for import into Mysql > > > Hi David! > > What language do you use to build your

Re: Convert dates for import into Mysql

Hi David! What language do you use to build your application? You can do this easily with PHP. Please have a look at the following functions http://se.php.net/manual/en/function.strtotime.php http://se.php.net/manual/en/function.strftime.php Best regards /Peter - Original Message - F

RE: convert ms access mdb file to file that can be imported in mysql

+44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxembourg -Original Message- From: Mertens Bram [mailto:[EMAIL PROTECTED]] Sent: 31 August 2002 17:20 To: mysql mailing list Subject: Re: convert ms access mdb file to file that ca

Re: convert ms access mdb file to file that can be imported in mysql

On Sat, 2002-08-31 at 17:59, David Lloyd wrote: > ( mysql, query ) > You have missed his point. He's asking Microsoft to support MySQL as a > native backend. I'm sorry if I was unclear, I'll try to clarify. I created a db under Windows using Access, I backed the .mdb files up. I have upgraded my

Re: convert ms access mdb file to file that can be imported in mysql

Andy, ( mysql, query ) > you could install MyODBC to write the tables directly from MS A. to MySQL > via ODBC. > > Works ok and did a good job for me. > > I've looked through the archives of this list but all methods of porting > > a ms access db to mysql seem to require installing additional

Re: convert ms access mdb file to file that can be imported inmysql

At 16:17 +0200 8/31/02, Mertens Bram wrote: >Hi, > >I've looked through the archives of this list but all methods of porting >a ms access db to mysql seem to require installing additional software >under Windows. > >Is there a tool available that converts an existing ms access db-file >(*.mdb) int

Re: convert ms access mdb file to file that can be imported in mysql

you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. Andy - Original Message - From: "Mertens Bram" <[EMAIL PROTECTED]> To: "mysql mailing list" <[EMAIL PROTECTED]> Sent: Saturday, August 31, 2002 4:17 PM Subject: co

Re: Convert function??

Ben, > I am looking for a command to interpreter the timestamp field into a > date time field much like the Convert function in MSSQL. Does anyone > know of a built in function for this or will I be off on the road to > building my own function? Beginning with v4.0.2, CAST | CONVERT( value AS t

RE: Convert ISAM table to MyISAM

Thanks for your help Victoria. Iago. -Mensaje original- De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Enviado el: jueves 14 de marzo de 2002 11:48 Para: [EMAIL PROTECTED] Asunto: Convert ISAM table to MyISAM Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS> I'm going t

Re: Convert table type

"Carsten H. Pedersen" wrote: > > We are looking to convert all ISAM tables to the new type MYISAM > > > > Has anyone else converted all tables in all their databases in one fell > > swoop to > > a new type? using the alter table command. > > > > Thanks for any gotchas, hints or suggestions. >

RE: Convert table type

> We are looking to convert all ISAM tables to the new type MYISAM > > Has anyone else converted all tables in all their databases in one fell > swoop to > a new type? using the alter table command. > > Thanks for any gotchas, hints or suggestions. A somewhat unconventional method which wo

Re: Convert to MyISAM

use: alter table type=myisam On Thu 06 Sep 2001 12:53, Lorang Jacques wrote: > Hello, > > I would be pleased if anyone could tell me hoe to convert my tables to > MyISAM. I used to run an old MYsql version, but now got the newest one, but > still my tables can't use the features of the new versi

RE: Convert Outlook into MySQL

Hi, > Does anybody knows if there is an easy and fast way to convert MS Outlook > 2000 contacts database into a MySQL table? It should be very easy for you to export your Contacts folder to MySQL. Simply choose the 'Import and Export...' menu command and tell Outlook to export to a tab-seperated

Re: convert an ms access database file

We haven't had a chance to test it yet, but the documentation for MySQL-Front (http://www.anse.de/mysqlfront/download.php) mentions a new feature which permits import of Access databases. MySQL-Front is a beta / free product at this point ... which we have foudn to very stable and very useful! G

Re: convert an ms access database file

Have a look at MySQL-Front: http://www.mysqlfront.de/ it will do extactly what you want. Please be careful: the ODBC/Access-Importing has beta-quality. Ansgar -Ursprüngliche Nachricht- Von: "Terrell Johnson" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Gesendet: M

RE: convert microsoft sql

Hi, You can use DBTools (for windows http://dbtools.vila.bol.com.br)) to convert the structure (without indexes) and data to mySQL by using ODBC DSN, or you can dump the data into a TXT file and then import it into mysql with LOAD DATA ... I'm working on a wizard to convert a completely structure

RE: convert microsoft sql

Mysql has a converter in it's package. Look under the scripts directory for MySQL. --- Brad Dameron Network Account Executive TSCNet Inc. www.tscnet.com

Re: Convert varchar to number field

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

"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