The problem is going to be with the data itself. For instance, let's say for a particular record that datex is empty {}, this would give you the error you describe.

>The below code works fine on my PC but under and EXE on a users PC it fails with an error 11 - function argument, value, type, or count is invalid.
>
>The original code used an IN (This.cAlias) and I replace that with a SELECT (This.cAlias) before the replace. I also added an 'X' to the end of each column that might be confused with a reserved word.
>
>Still get the same error. Anyone see anything wrong with this?
>
>

>      REPLACE namex     WITH LOWER( namex )                                  ,;
>              datetimex WITH DATETIME( YEAR( datex )                         ,;
>                                      MONTH( datex )                         ,;
>                                      DAY( datex )                           ,;
>                                      INT( VAL( SUBSTR( timex, 1, 2 ) ) )    ,;
>                                      INT( VAL( SUBSTR( timex, 4, 2 ) ) )    ,;
>                                      INT( VAL( SUBSTR( timex, 7, 2 ) ) ) )  ALL
>