LIKE subquery

[Shihtzu]

Hi,

How do i perform like sql subquery in vb.net ?

i tried

("SELECT petName FROM faculty where petName LIKE %'@teacherN'% ", connection)

command.parameter.add("@teacherN",textbox1.text)

but it doesn't return anything to me even though it should .. any idea?

 

[Shihtzu]

even though i tried

("SELECT petName FROM faculty where petName LIKE '%@teacherN%' ", connection)

it cannot be done as well

 

[lingsn]

May be try

("SELECT petName FROM faculty where petName LIKE '@teacherN' ", connection)

command.parameter.add("@teacherN","%" & textbox1.text & "%")