>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.

Try

SELECT * FROM ACT_PLANT WHERE SUBSTR(INTERTITLE, 2, 1) = 2