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

lingers

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

dharmend...

0 1

Hi lingers,

Use below query.

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html