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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2010-02-11 : 05:39:46
|
| Hi,Is it possible in sql server 2005 to write something similiar to this:where firstname like 'burno' (to return firstname= burno and not firstnames that contain the phrase burno)Is this equivalent to where firstname='burno'?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-11 : 05:44:30
|
| if you want exact match use =if you want pattern match use LIKE with wildcard characters like %,_,etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-11 : 06:00:30
|
| Yeswhere firstname like 'burno' is equal towhere firstname ='burno'MadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-11 : 06:38:28
|
"is equal to"Does SQL Query Planner optimise a LIKE, with no wildcard characters, to Equals? If not EQUALS will be better than LIKE in that scenario  |
|
|
|
|
|
|
like and equal to operator