I have table like this with 2 column (Code and Name)
If I insert Name "Anthoni", the Code will auto generate "A1"
If I insert Name "Alan", the Code will auto generate "A2"
But if I insert Name "Billy", the Code will auto generate "B1"
How to do that?
Thank you