I have table with following data in my database:
DOC_NO |
CNMARA |
CNJULB |
CNJULA |
CN39A |
CN32A |
CN317 |
CN316 |
I want to fetch max doc_no from following dataset,Current if i fetch max from this dataset the data which i get is 'CNMARA' but i want is 'CN317'
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
You want to consider the only numeric value in the string or string and number both?
Chaitanya
Both String and number but Character in String Should be CN and then max Number .
Vinish Kapoor
Try the below one:
Chaitanya
Thank You Vinish.