如何查找混合文本内容的所有匹配记录 [英] How to find all matching records for the mixed text content

问题描述

我的表格中有一个值如下所示



123 -456



但在搜索条件（UI）中，我正在搜索此值，如

Hi ,

I have value in my table one of the column like below

123-456

But in search criteria(UI) i am searching this value like

all possible combinations given below 
 
0123-456
123=-456
R123-456

but i need that exact value that is present the table 123-456  
using sql server 2008R2 query.

Please give me the solution it will be help full for me

What I have tried:

i tried with free text and contains but not working

推荐答案

嗯...

Um...

SELECT * FROM MyTable WHERE MyColumn='123-456'

我无法相信你问过的问题是你想要回答的问题......

I can't believe that the question you have asked is the one you wanted answered...

这篇关于如何查找混合文本内容的所有匹配记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！