I have a really situation where the modification to code is limited
I would like to look for a word in column lets take the following two values in a column
"The best transportaion means is"
"Transportation is best by"
if user types in 'trans' I should be able to find both results
if they type in the whole word I should be qable to find it
if they tyoe "rans" no results should be returned
I have an application that submits this to a stored proc
I cant modify the stored proc so at this point this is what I have in the stored proc
@SearchTerm -->is a stored proc paramter
where column like @SearchTerm
The application does this now
if the user types in trans it takes it and appends % to it
so this retrieves the result only for columns starting with trans
but can't find this "The best transportaion means is"
if I do in the application '% ' + 'trans' + %
That will find "The best transportaion means is"
but wont find the first value
Any ideas how I can resolve this