Hi all,

I have a need in a view to create a 3 digit wide blank numeric column that is filled in after the view is queried. The only way I could figure out how to do this is to insert an IIF() in as an expression to the view designer something like this (this is the resulting SQL SELECT):

SELECT Quotes.*, IIF(.T.,000,000) AS Years ;
   FROM Quotes...

The problem is, the view designer wants to keep stripping out the extra zeros if you edit the view so that it becomes IIF(.T.,O,O) and I end up with a 1 digit wide column created...which causes numeric overflow. I don't want to have to switch to using a character column as that would be a lot of grief. Any better way to get a multi-digit column from within the view designer?

Thx.
Albert