Sign up using Facebook.
NET I have a form where you type in either the SKU number or the name of the item into a text box and then press enter to search the database for that number or a similar name to the one you searched.
Kevin Horgan Kevin Horgan 1,492 17 20. However, when I need to make the match using a variable for B01 and that the variable is set with a select statement, I don't get any results returned. Sign up or log in Sign up using Google. You should use LIKE rather than equals operator in order to use pattern matching: The escape character has no default value and must be evaluated to only one character.
Related 2779. Page address: Pattern Matching in Search Conditions.
It appears that using the LIKE in a condition with wildcards and a variable inside of dynamic sql doesn't work, although it doesn't give an error.
Is there anything wrong with that statement?
I confirmed that the select statement above returns the expected code, however. Sign up or log in Sign up using Google. Post as a guest Name.
It would be helpful to DJDMorrison if you could supply an example or a link to the use of bind variables. A pattern may include regular characters and wildcard characters.