Find a string based on input Characters in sql

Question

How to find a string based on input characters in sql?

For example:

Table1 column name: desc

data warehousing
sql serverl
c#.Net
asp.net

My input: @FindString='dho' should return 'data warehousing'
My input: @FindString='sv' should return 'sql serverl'
My input: @FindString='aep' should return 'asp.net'

How to do that?

You will need to use FTS with its "Inflectional forms search feature for this read here for more information on Full-text Search — M.Ali
– M.Ali, Commented Feb 10, 2014 at 7:24
@marc_s: yes, it may contain any order. String must have all characters. — Ram
– Ram, Commented Feb 10, 2014 at 7:29

Behrad Farsi · Accepted Answer · 2014-02-10 08:17:34Z

1

Go with this code:

SELECT * FROM table WHERE field like '%d%' AND field like '%h%' AND field like '%o%'

I mean you should surround each character of input string with %.

edited Feb 10, 2014 at 8:17

answered Feb 10, 2014 at 7:24

Behrad Farsi

1,11013 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ram Over a year ago

It may contain any order. I mean •My input: @FindString='aep' should return 'asp.net'

Behrad Farsi Over a year ago

Use This : SELECT * FROM table WHERE field like '%d%' AND field like '%h%' AND field like '%o%' .

Amir Sherafatian · Accepted Answer · 2014-02-10 10:16:09Z

0

i think you want this :

declare @inputString nvarchar(max) = 'eap';

declare @where nvarchar(max) = 
    case @inputString 
        when 'dho' then 'data warehousing'
        when 'sv' then 'sql serverl'
        when 'eap' then 'asp.net'
    else ''
    end

select * from Table1
    where desc = @where

also your query can be like this:

declare @inputString nvarchar(max) = 'dho'

select * from 
   (select
        case [desc]
            when 'data warehousing' then 'dho'
            when 'sql serverl' then 'sv'
            when 'asp.net' then 'aep'
            else ''
        end 
        as [newDesc]
    from [table])t
where newDesc = @inputString

edited Feb 10, 2014 at 10:16

answered Feb 10, 2014 at 8:42

Amir Sherafatian

2,0932 gold badges21 silver badges32 bronze badges

Collectives™ on Stack Overflow

Find a string based on input Characters in sql

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related