請問個位大大:
VB 2008 中sql 多個萬用字元的寫法 該如何寫呢?目前我想在%後面再加上一組 MNameMi
而MNameMi 為料號中的MNameMi = Strings.Right(MNameM, Len(MNameM) - 7) '右邊取第八碼
MNameL = Strings.Left(MName, 5) '左邊取五碼
where ((料號 like '" & MNameL & "0" & "%' " & _
" or 料號 like '" & MNameL & "1" & "%' ) " & _
也就是我前五碼由料號取得第六碼可為0或1 第七碼可為任意數第八碼由料號取得 該如何寫呢?
以上程式碼是我前五碼由料號取得第六碼可為0或1 第七八碼以後為任意數
感謝各位大大
SELECT
*
FROM (
SELECT '1234507890' AS [料號]
UNION ALL
SELECT '1234567890' AS [料號]
UNION ALL
SELECT '1234517890' AS [料號]
UNION ALL
SELECT '1234567890' AS [料號]
) T1
WHERE T1.[料號] LIKE LEFT([料號], 5) + '[01]_' + SUBSTRING([料號],8, 1 ) + '%' |