How can I run a query that will return only those records where the ID field contains two leading letters?
Some of the IDs are 100% numeric but some of them are formatted like XX12314. I only want to return those where the two leading characters are any letter.
Is ISNUMERIC the best solution here or is there a better way to do it?