回答編集履歴
2
元にもどした
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
```SQL
|
18
18
|
|
19
|
-
AND (Memo Like ISNULL(@strMemo, Memo) OR Memo IS NULL)
|
19
|
+
AND (Memo Like ISNULL(@strMemo, Memo) OR ISNULL(@strMemo, Memo) IS NULL)
|
20
20
|
|
21
21
|
```
|
22
22
|
|
1
間違えた
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
```SQL
|
18
18
|
|
19
|
-
AND (Memo Like ISNULL(@strMemo, Memo) OR
|
19
|
+
AND (Memo Like ISNULL(@strMemo, Memo) OR Memo IS NULL)
|
20
20
|
|
21
21
|
```
|
22
22
|
|