I am using a where = statement (in asp.net)

WHERE = "my_value"

("my_value is a variable a user passes entering a Form)

It works fine only if the user's search matched exactly my database value: say if he entered 'Martin Scorsese'

However if he entered only "Scorsese" his search does not give any result.
Any way out with this?
Many thanks
Shirley

Use WHERE LIKE '%my_value%' instead

http://sqlservercode.blogspot.com/

I will have a go and let you know.
Many thanks

WHERE Titolo LIKE '%"+requestedValue+"%'

it works perfectly
many thanks!:)