Hi!
What type of the data you have? If numeric values, you will need to convert them to character data type. Following is example of query into array:
SELECT padr(ltrim(str(MyNumericField,14,2)),14) from ...
The benefit is that you also can use any formatting you want, specially when you will use 'transform' function instead of 'str'.
To convert character data back to numeric, use val() function.
>I have a form with a list box that is populated by an array that is made in the init of the form. The list box has 5 columns. My problem is the alignment of the data in each column, they seem to align in the center. I would like them right justified. I cannot find a method to do this. What am I missing? Thanks for the help.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.