sql querry

Suresh Babu

testcode           eligibility(subjects)
100                8,26,36,40
101                18,56,87,10
102                38,28,46,11
103                48,128,58,68

this is my sample data

my question is
i want to retrieve the data from the above table depending on user requmnt
if user choose the subject no 8 then he had to get only 100 row not only remaining rows
if user choose the subject no 28 then user to get only 102 row not the 102 & 103
please help me how to write the command . please help me

thanks in advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhruvil Shah7y ago
Hello Suresh Babu,

You need to pass where condition like '%,28,%' & migrate your eligibility column data like below :-

,8,26,36,40,

,18,56,87,10,

,38,28,46,11,

,48,128,58,68,

Add comma previous & end of the value.

Sql query will be like :-

select eligibility from #tmpFileTypePermission1 WHERE eligibility like '%,28,%'

Here, is sample code :-

CREATE TABLE #tmpFileTypePermission1

(

eligibility varchar(max)

);

INSERT INTO #tmpFileTypePermission1 VALUES (',8,26,36,40,')

INSERT INTO #tmpFileTypePermission1 VALUES (',18,56,87,10,')

INSERT INTO #tmpFileTypePermission1 VALUES (',38,28,46,11,')

INSERT INTO #tmpFileTypePermission1 VALUES (',48,128,58,68,')

select eligibility from #tmpFileTypePermission1 WHERE eligibility like '%,28,%'

DROP TABLE #tmpFileTypePermission1

Let me know if you have any concern.
Jignesh Kumar7y ago
Hi Suresh, Please find below link where its pretty easy way to do, you can use IN clause https://www.aspsnippets.com/Articles/Use-Comma-Separated-Delimited-string-values-with-IN-and-WHERE-clause-in-SQL-Server.aspx
Purvi Barot7y ago
You can use like operator for this !
here is the query:
select testcode from Table_1 where eligibility like '8,%' or eligibility like '%,28,%'
reference link for LIKE operator :

1. https://www.w3schools.com/sql/sql_like.asp

2. https://www.tutorialspoint.com/sql/sql-like-clause.htm

Thank you !
Ahmar Husain12y ago
use wildcard like this :-
(consider the example of 28)

select testcode from table name where eligiblity like '%,28,%' or eligiblity like '28,%' or eligiblity like '%,28'