Right() function in SQL

[wavp]

I am trying to use the Right(0 function in SQL, I used it in A97 and it worked, but it doesnt work in A2k.

Example:

SQL_ADD = "INSERT INTO TMP_E SELECT '" & strCNum & "' AS IP_CNum,'" & strDate & "' AS IP_Date,'" & strSNCut & "' AS M_Serial, Right(Name,10) As FC_Code, Data As FC_Count FROM TMP_CII;"

Any ideas??

Cheers

Will

 

[Mile-O]

Have you checked your references? Search on this forum if you don't know what I mean.

The Right function certanly does work; you are probably missing a library.