ถ้าผมเอา T0.custmrName LIKE N'%ธนาคาร%' ออกมีข้อมูลแสดง แต่ถ้าใส่จะไม่มีข้อมูลแสดง เพราะอะไรครับ แนวทางแก้ยังไงได้บ้างครับ Code (SQL)
SELECT
CONVERT(varchar(10),T0.createDate,103) as createDate,
T0.createTime,
CONVERT(varchar(10),T0.closeDate,103) as closeDate,
T0.closeTime,
CONVERT(varchar(10),T0.U_DateJobStart,103) as DateJobStart,
T0.U_TimeJobStart,
CONVERT(varchar(10),T0.U_DateJobEnd,103) as DateJobEnd,
T0.U_TimeJobEnd,
T0.custmrName,
T0.subject,
T0.itemCode,
T0.CallID,
T0.internalSN,
T0.manufSN,
T0.resolution,
T3.Name as serviceCode,
T4.Name as status,
T1.U_ServiceContract
FROM OSCL T0
INNER JOIN OINS T1 ON T0.insID = T1.insID
INNER JOIN OSCT T3 ON T0.callType = T3.callTypeID
INNER JOIN OSCS T4 ON T0.status = T4.statusID
WHERE T3.Name = 'BSD'AND (T4.Name LIKE 'Open' AND T0.custmrName LIKE N'%ธนาคาร%')
ORDER BY T0.createDate DESC