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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 15:32:58
|
Gilles writes "I have to transform a lot of Access Queries into T-SQL Syntax,
so for Access 'IIF' I want to take 'case'.
But how can I use a 'like' in the query ?
For example:
SELECT
Test=case name
when like 'premiere' then 'Heute PREMIERE: '
else name
from test_table order by test desc
Any better ideas ?
Thanks for your help,
Gilles
Win 2K Prof. SP 1 with SQL Server 2000" |
|
|
|
|
|
case with like