Hi,
I am using sqlitespy
What I need is a query which would be able to recognize all the letters or numbers or hypen in values in column a and would give me result in column b as: T for Text, N for number and "-" for "-".
so for an example:
column a > column b
abc > ttt
a1c > tnt
aaaa3333aaa > ttttnnnttt
a-333 > t-nnn
Hello Sir., I am ready to start it.i am highly interested in your project But i have some questions for you. So kindly leave message for me, then i'll discuss it in depth