Keep in mind that such query wil not be optimizable.
SELECT * FROM mytable WHERE Item_no LIKE '__002%'
>
>I have an item number as column on my table, this column is a char(10) size. Its look like this.
>
>Item_no
>-------
>010010001
>010010002
>010010003
>010020001
>010020002
>020020001
>
>The description of the field as follows:-
>
>xx is the catcode
>xxx is a subcode
>xxxxx is the serial number
>
>How to search the table look for item number with subcode of '002', normally we are using str() function in vfp to do this job.
>
>Best Regards
--sb--