从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屋！