>>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.
>
Whoops, typo. Make that
>
SELECT * FROM ACT_PLANT WHERE SUBSTR(INTERTITLE, 2, 1) = '2'