select 000000000000 as intcolumn from yourtable into cursor yourcursor
Rafael Copquin ----- Original Message ----- From: "Gérard Lochon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 25, 2008 1:57 PM Subject: SQL VFP6 Integer Hello guys. My mind is out my brain today, so i don't scope a simple solution for a simple problem : I don't remember how to create a new column containing an integer only using a select statement. i.e : select space(4) as myfield,* from toto && will create a add field, with four space chars. what must i select xxx, * from toto to create an integer column ?? Thanks by advance. Gérard. ____________ Analysé par G DATA AVK Version : AVK 19.108 de 25.08.2008 Informations sur les virus : www.antiviruslab.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
