I have select sql statement and it shouldnt distinguish two types of formats. Currently, I have:
rank() over(partition by kki_nbr order by discharge_date desc)
And kki_nbr can be following two formats:
these two formats should consider as same value.
so, how do I detect those two formats as same format?