I have table where one of the columns is called COL1.
Suppose this table has just one record where the column COL1 has the value 56006*.
I want to select the above record even when I look up this table for records with COL1 value = 560068.
How can I write such a query?
Thanks & Regards,