Hi,
I am using the following select criteria to filter my results
instr(1,[F:BOD]CPNITMREF,'X')
which returns things like: HSCX3UAE17, PXL8, X0011
However I only want results starting with the letter 'X'.
How do I amend my syntax so that its looks for 'X' in position 1 ONLY, not starts from position 1.
Regards & Thanks