Hi:

I'm trying to run a query where I list all the records that have 2 as the second character in the field, i.e. 1234, 0234, 4290
Simple enough, this query only gives me records with the value of 2. The intertitle field is character 4.


select * from act_plan where val(left(intertitle,2)) = 2

Thanks.

M.