Hello,
I am creating a database where i want to generate ID based of Names
e.g
I have a table called Products and if I add a product named Apple the id generated is A001 and when i add another product starting with A the next id generated is A002 and for product starting with B should be B001 and so on.
How can i achieve this? Please help...