Hi, I want to make a setrange(Code1,code2), where, as an example, code1 = ‘ABCD 1234’ and code2 = ‘ABCD’. So, is it possible to ‘shorten’ code1 to the length of code2, so that only the first 4 letters are compared? Michael
You will need to use the SETFILTER command rather than SETRANGE I think. Presume you wish to apply the filter of ‘ABCD*’ to the Code 1 Field??? Setfilter(“Code 1”,’%1’,“Code 2” + ‘*’); this may work.
Thank’s Andrew, it works.
You are very welcome.