Sai Reddy

Sai Reddy

  • 1.8k
  • 212
  • 13.8k

Calculate sum alphabets with given string?

Jul 12 2018 7:03 AM
 I have a requirement as follows.
String=Praveen(passing it as parameter in stored procedure)
i need to calculate each character alphbitacal number and sum of them
ex: 1+15+30+9+1+2=58
result is 5+8=13
i need it as a stored procedure in mysql and sql server?

Brought to you by:

Answers (15)