从SQL Server中的列值中查找匹配的字符串 [英] Find matching string from column values in SQL Server
问题描述
Hello Experts,
我有一个表名StData,这样的结构
PaperNo  ;                        &NBSP ;                        &NBSP ;       批量
A123123        &NBSP ;                        &NBSP ;                         A0-A12-A13-A14-A15
A234234                                             A12-A14
A345345                                          A14
A456456                                         A0-A12-A16
批次栏在测试时具有不同批次的值。
现在,我想要一个Sql查询,这样它就会给我所有PaperNo的A14批次。
URGENTLY 需要帮助解决它...
Hello Experts,
I have a table name StData, Structure like this
PaperNo Batch
A123123 A0-A12-A13-A14-A15
A234234 A12-A14
A345345 A14
A456456 A0-A12-A16
Batch Column have values of different batches given the test.
Now, I want a Sql query so that it will give me all PaperNo of "A14" batch.
URGENTLY Need Help to solve it ...
推荐答案
尝试:
Try:
SELECT PaperNo FROM StData WHERE Batch LIKE '%A14%'
Select PaperNo from StData where batch like %A14%
试试这个
Try This
select PaperNo from StData
where Batch Like '%A14%'
这篇关于从SQL Server中的列值中查找匹配的字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!