利用 charindex 指令取出該欄位裡用【 | 】作區別的字
##### 原始的語法 ####
select emp.CompID,emp.EmpID, emp.WorkTypeID,emp.WorkType
from HRISDB.DBO.EmpShare emp where empid='A00595'
##### 改過後的語法 ####
select emp.CompID,emp.EmpID,
case when charindex('|', emp.WorkTypeID) > 0 then
left(emp.WorkTypeID, charindex('|', emp.WorkTypeID) - 1)
else emp.WorkTypeID end WorkTypeID,
case when charindex('|', emp.WorkType) > 0 then
left(emp.WorkType, charindex('|', emp.WorkType) - 1)
else emp.WorkType end WorkType
from HRISDB.DBO.EmpShare emp where empid='A00595'
文章標籤
全站熱搜
