Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-06-21 : 10:52:07
|
| Hi,I am passing a parameter called @nameI would like to use the like keywork such that if the parameter is 'ephe' then the name 'stephen' is returnedThis does not work --> like '%@name%'Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-21 : 10:54:08
|
| like '%' + @name + '%'Be One with the OptimizerTG |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-06-21 : 10:54:10
|
like '%' + @name + '%'Go with the flow & have fun! Else fight the flow  |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-06-21 : 10:54:43
|
| like '%' + @name + '%'HTH=================================================================All restraints upon man's natural liberty, not necessary for the simple maintenance of justice, are of the nature of slavery, and differ from each other only in degree. -Lysander Spooner, lawyer (1808-1887) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-06-21 : 10:55:13
|
 by 2 seconds... :)Go with the flow & have fun! Else fight the flow |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-21 : 10:55:28
|
| YES!!! a double !!Be One with the OptimizerTG |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-06-21 : 19:31:38
|
| Is there an echo in here???HTH=================================================================All restraints upon man's natural liberty, not necessary for the simple maintenance of justice, are of the nature of slavery, and differ from each other only in degree. -Lysander Spooner, lawyer (1808-1887) |
|
|
|
|
|
|
like