I have a column that contains license plates, and need to build a where clause that uses replacement values for zero and the letter ‘O’. How can this be done in tslq? Examples:
Plate, (where clause needed)
ABC012, (ABC012, ABCO12)
0OABC, (00ABC, OOABC, 0OABC, OOABC)
000XYZ, (000XYZ,00OXYZ,0OOXYZ,0O0XYZ,O00XYZ,O0OXYZ,OOOXYZ,OO0XYZ)