Select CASE when ('001-010-003' like '001-010-%' ) then (select DeptAbbName from Department where DeptID=(select ParentId from Department where Department.DeptId=(select ParentId from Department where Department.DeptCode='001-010-003'))) ELSE (select DeptAbbName from Department where Department.DeptId=(select ParentId from Department where Department.DeptCode='001-010-003')) end
Select CASE when ('001-010-003' like '001-010-%' ) then 1 ELSE 2 END,CASE when ('001-010-003' like '001-010-*' ) then 1 ELSE 2 END你执行下,是不是有一个1有一个2
then (select DeptAbbName from Department where DeptID=(select ParentId from Department where
Department.DeptId=(select ParentId from Department where Department.DeptCode='001-010-003')))
ELSE (select DeptAbbName from Department where
Department.DeptId=(select ParentId from Department where Department.DeptCode='001-010-003'))
end
then 1
ELSE 2
END,CASE when ('001-010-003' like '001-010-*' )
then 1
ELSE 2
END你执行下,是不是有一个1有一个2