问一个关于视图字符匹配的问题!请大家帮忙

[lvxz]

我想创建一个视图vv_query,要求权证编号输出为0或1或2或3等

但是在vv_cursteps表中的权证编号类似于"开私0512036","开国012465","开外1546"等,但是我想用%却实现不了这样的功能

CREATE VIEW dbo.vv_query
AS
SELECT 受理编号,
case [权证编号]
when '开私%' then 0
when '开外%' then 1
end as 权证编号
FROM dbo.vv_CurSteps

请大家帮忙想想办法,好象视图中对识别不出"%"这个匹配值

[xluzhong]

CREATE VIEW dbo.vv_query
AS
SELECT 受理编号,
case [权证编号]
when [权证编号] like N'开私%' then 0
when [权证编号] like N'开外%' then 1
end as 权证编号
FROM dbo.vv_CurSteps

[onebody]

Create Table vv_cursteps (权证编号 VarChar(100))

Insert vv_cursteps
Select '开私0512036'
Union All
Select '开国012465'


CREATE VIEW dbo.vv_query
AS
Select (Case
When Left(权证编号,2)='开私' Then 0
When Left(权证编号,2)='开国' Then 1
End) As 权证编号
From vv_cursteps

Drop Table vv_cursteps
Drop View vv_query

[onebody]

或
Create Table vv_cursteps (权证编号 VarChar(100))

Insert vv_cursteps
Select '开私0512036'
Union All
Select '开国012465'


CREATE VIEW dbo.vv_query
AS
Select (Case
When 权证编号 like N'开私%' Then 0
When 权证编号 like N'开国%' Then 1
End) As 权证编号
From vv_cursteps

Drop Table vv_cursteps
Drop View vv_query

[lvxz]

谢谢大家!
我已经解决了
CREATE VIEW dbo.vv_query
AS
SELECT 受理编号,
case left (权证编号,2)
when '开私' then 0
when '开外' then 1
end as 权证编号
FROM dbo.vv_CurSteps