Hi Lil,

You may find using Left$([F:BOD]CPNITMREF,1) within the instr() in your criteria works. I am not sure where you are using this criteria to test.

Regards

David

Hi David,

Thank you for your reply. I am using this in a requester on the 'Advanced' tab in the 'Selections'\Selection criteria.

I tried adding your additional syntax above in replace of the '1' but that didn't work, I got three consecutive errors:

 - c:\sage\....\adxodbc : Incompatibility of type

 - Application error. Contact your administrator

 - (Incompatibility of type)

I tried variating the syntax a few ways to include the Left$ function but each time received the above errors. Can you please advise how the syntax would be correctly included to make this work for me.

Regards & Thanks

Lil

Hi David,

Thank you for your reply. I am using this in a requester on the 'Advanced' tab in the 'Selections'\Selection criteria.

I tried adding your additional syntax above in replace of the '1' but that didn't work, I got three consecutive errors:

 - c:\sage\....\adxodbc : Incompatibility of type

 - Application error. Contact your administrator

 - (Incompatibility of type)

I tried variating the syntax a few ways to include the Left$ function but each time received the above errors. Can you please advise how the syntax would be correctly included to make this work for me.

Regards & Thanks

Lil

Hi Lil,

Sorry I should be been more specific I meant to use this

instr(1,left$([F:BOD]CPNITMREF,1),'X')

Certainly in my test I get back all components starting with X 

The left$ will just include the first character of CPNITMREF, so the instr has just the one character to search to find the X

Alternatively if it only going to be the first character then this may be better to just use

left$([F:BOD]CPNITMREF,1)="X"

Hi David,

That works perfectly thank you.

Kind Regards

Lil