Like '%abc%' Clause In Stored Procedure Problem?

I write a stored procedure as:





select * from tableName where firstName like '%' + @keywords + '%'


(assuming @keywords is declared with varchar)








when I use QA, it runs perfect and returns something that has words in between for matching up firstName, but when I use with the following code (Data access layer) it wouldn't return.. it will only return the matched text.. (ex. if i input 'ke', it suppose return kelvin, kelly, okey something like that, but somehow it only retunrs the whole words that's matched)





Is there something wrong? The code for DAL is as follows.





Public Function GetOrderList(ByVal keywords As String) As DataSet


Dim myConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))


Dim myCommand As SqlDataAdapter = New SqlDataAdapter("sp_GetList", myConn)





myCommand.SelectCommand.CommandType = CommandType.StoredProcedure





Dim paramKeywords As SqlParameter = New SqlParameter("@keywords", SqlDbType.NVarChar)


paramKeywords.Value = keywords


myCommand.SelectCommand.Parameters.Add(paramKeywords)





Dim myDS As New DataSet


myConn.Open()


myCommand.Fill(myDS)


myConn.Close()





Return myDS


End Function