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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-02-22 : 10:03:43
|
| Ok I've used SQL 7 for 2 years and I know for a fact that my queries have worked by using:Select * from sometbl where somecol like 'abc*'Now under SQL 2k this does not work. Did MS change the standard wild card so I must now use 'abc%' rather than 'abc*'???Whats this all about?DanielSQL Server DBA |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-22 : 10:36:47
|
quote:
Ok I've used SQL 7 for 2 years and I know for a fact that my queries have worked by using:Select * from sometbl where somecol like 'abc*'
Dan, are you sure those weren't MS-Access queries? 'Cause in SQL Server % was always the wildcard. |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-02-22 : 11:01:27
|
quote:
quote:
Ok I've used SQL 7 for 2 years and I know for a fact that my queries have worked by using:Select * from sometbl where somecol like 'abc*'
Dan, are you sure those weren't MS-Access queries? 'Cause in SQL Server % was always the wildcard.
Hmm, Maybe I've gotten myself a bit confused... I'm in the process of migrating some Access 97 DB's to SQL 2k and perhaps I've just looked at Access a bit too long and burned the * into my cornea or pupil  In any case its been 2 months of non-stop Access 97 for me and I guess it has fooled me into thinking of '*'ThanksDanielSQL Server DBA |
|
|
|
|
|
|
Like clause has changed syntax???