Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Select with math
Hi All,
I have a SQL SELECT statement that selects data into an array. The array is passed to an Excel spreadsheet for a report. One field in the VFP table is defined as 99.999. I don't "control" the data format. The user wants that field in the Excel column to contain a "%". The problem is that to format the column in Excel with an "%" it automaticaly multiplies by 100.
This is a long way of asking - is there a way, in the SELECT statement, to specify a field divided by 2. "SELECT rate/2 From..... does not seem to work. I've searched several manuals on SQL and see no pertinent examples TIA.
Regards,
Paige
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement