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

on Apr 30, 2021 06:02 AM

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
on Apr 30, 2021 06:03 AM

Hi lingers,

Use below query.

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