See CAST() function.
SELECT Quotes.*, CAST(0 AS N(3)) AS Years ;
...
>
>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
--sb--