Hi,

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