Roelaux, this might help.


>>MAGIC = 42
>>MyNumber = "MAGIC"
>>? TYPE(MyNumber)
>>? LEN(MyNumber)
>>
>This part I get!!
>It is N because of the lack of " " around 42. Correct?

This should be;
MAGIC = 42
MyNumber = "MAGIC"
?TYPE(&MyNumber) <-- The '&' creates an indirection to Magic's value.
?LEN(&MyNumber)

Another example, would be;

lc_alias = ALIAS() && the currently selected table

SELECT 100 && select some other table

SELECT &lc_alias && If lc_alias is empty, this will cause an error.


Rob.