I run this query in access pointing to Oracle
SELECT CInt(Right(Trim(mse_name),4))
FROM db_own
WHERE ((Left([mse_name],4))='DB19') and
len(trim(mse_name)) = 8 and
CInt(Right(Trim(mse_name),4)) > 70
I get Invalid Number error. It is the where 'CInt(Right(Trim(mse_name),4)) > 70' giving problem. If I delete above line in where clause it works fine. I am connecting to Oracle db
to run this query. I though cint does convert to number. Why is this error coming up I have only numbers there ...
SELECT CInt(Right(Trim(mse_name),4))
FROM db_own
WHERE ((Left([mse_name],4))='DB19') and
len(trim(mse_name)) = 8 and
CInt(Right(Trim(mse_name),4)) > 70
I get Invalid Number error. It is the where 'CInt(Right(Trim(mse_name),4)) > 70' giving problem. If I delete above line in where clause it works fine. I am connecting to Oracle db
to run this query. I though cint does convert to number. Why is this error coming up I have only numbers there ...