Last post Dec 25, 2019 06:07 AM by Dhoni
Dec 21, 2019 02:03 PM|Dhoni|LINK
This is my values "A1,A2,A3...........A100......A1000". How to get the
max value After "A"
So how to write the query for get the values....
Dec 23, 2019 06:55 AM|samwu|LINK
How to get the max value After "A"
According to your description, I couldn’t understand your requirement clearly.
Do you mean you to split these values, then get the max number among these split value in the sql server?
If this is your requirement, I suggest you could use the substring() method to split the value then get the max value.
select * from Test2
select max(convert(int,substring(AValue,2,100))) from Test2
If I misunderstand your requirement, please post more details information about your requirement.
Dec 25, 2019 06:07 AM|Dhoni|LINK
Thank you ,it was very helpful to me