从表中获取字母数字最大值 [英] Get alpha numeric max value from a table

问题描述

大家好，



我购买了一个表名 - 两列是PurchaseID和PurchaseCode

PurchaseID以100开头（标识）我需要当我的页面加载我的文本框显示purchasecode =

PO-101我该怎么做。 （这里是PurchaseID（int），PurchaseCode（Nvarchar（10））





谢谢

Hi All,

I have a table name purchase- the two columns are PurchaseID and PurchaseCode
PurchaseID starts with 100(identity) and I need when my page load my text box show purchasecode =
PO-101 how can i do that. ( here PurchaseID(int), PurchaseCode(Nvarchar(10))


thank you

推荐答案

检查此小提琴 [ ^ ]

check this fiddle [^]

--using top 1 and order by 
-- if you need to get the full id 
select top  1 SUBSTRING(id,  CHARINDEX('-',id)+1, DATALENGTH(id)), id
from Test order by 1 desc;
-- using max

select max(SUBSTRING(id,  CHARINDEX('-',id)+1, DATALENGTH(id)))
from Test;

如果你需要建造从整数列数据中获取PO然后尝试使用

If you need to build PO from integer column data then try with

-- buld PO's from id

select 'PO-' + CONVERT(varchar(10), id) from Test2

示例 [ ^ ]

这篇关于从表中获取字母数字最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！