Select record from database column containing array of string in SQL Server

lingers
 
on Apr 30, 2021 06:02 AM
587 Views

How do i select a column value in an array in a database

If i do select * from dbase where no='GC6641' it returns a null value but if i do select * from dbase where no='["GC6641"]' returns value.

I want to select values into gridview that is select phone,no,address from student.

But because the no is inside an array it doesn't bring out any value.

Please help

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Apr 30, 2021 06:03 AM

Hi lingers,

Use below query.

select * from dbase where no='%GC6641%'