|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
January 22nd 10, 09:09 PM
posted to microsoft.public.outlook.program_addins,microsoft.public.sqlserver.programming
|
|||
|
|||
WHERE without using CASE
I'm trying to edit a Filter in Outlook and it has a sort of SQL syntax. The
only thing is I don't know if it accepts CASE statements -- it's giving a 'SQL parsing' error. Is there another simple SQL way of doing this WHERE clause without using case (e.g. using AND or OR)?: WHERE (CASE WHEN (MyField1 IS NULL) THEN (MyField2) ELSE (MyField1))1 My Reference: (CASE WHEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1" IS NULL) THEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField2") ELSE ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1"))1 
|
|
#2
January 22nd 10, 09:19 PM
posted to microsoft.public.outlook.program_addins,microsoft.public.sqlserver.programming
|
|||
|
|||
|
WHERE without using CASE
Think I may have it:
WHERE (MyField11 AND MyField2 IS NULL) OR ((MyField2 IS NOT NULL) AND MyField21) "Mark B" wrote in message ... I'm trying to edit a Filter in Outlook and it has a sort of SQL syntax. The only thing is I don't know if it accepts CASE statements -- it's giving a 'SQL parsing' error. Is there another simple SQL way of doing this WHERE clause without using case (e.g. using AND or OR)?: WHERE (CASE WHEN (MyField1 IS NULL) THEN (MyField2) ELSE (MyField1))1 My Reference: (CASE WHEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1" IS NULL) THEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField2") ELSE ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1"))1
|
|
#3
January 22nd 10, 09:21 PM
posted to microsoft.public.outlook.program_addins,microsoft.public.sqlserver.programming
|
|||
|
|||
|
WHERE without using CASE
You could do
0WHERE MyField1 1 OR (MyField1 Is Null AND MyField2 1) Tom "Mark B" wrote in message ... I'm trying to edit a Filter in Outlook and it has a sort of SQL syntax. The only thing is I don't know if it accepts CASE statements -- it's giving a 'SQL parsing' error. Is there another simple SQL way of doing this WHERE clause without using case (e.g. using AND or OR)?: WHERE (CASE WHEN (MyField1 IS NULL) THEN (MyField2) ELSE (MyField1))1 My Reference: (CASE WHEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1" IS NULL) THEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField2") ELSE ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1"))1
|
|
#4
January 22nd 10, 09:34 PM
posted to microsoft.public.outlook.program_addins,microsoft.public.sqlserver.programming
|
|||
|
|||
|
WHERE without using CASE
Thanks.
"Tom Cooper" wrote in message ... You could do 0WHERE MyField1 1 OR (MyField1 Is Null AND MyField2 1) Tom "Mark B" wrote in message ... I'm trying to edit a Filter in Outlook and it has a sort of SQL syntax. The only thing is I don't know if it accepts CASE statements -- it's giving a 'SQL parsing' error. Is there another simple SQL way of doing this WHERE clause without using case (e.g. using AND or OR)?: WHERE (CASE WHEN (MyField1 IS NULL) THEN (MyField2) ELSE (MyField1))1 My Reference: (CASE WHEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1" IS NULL) THEN ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField2") ELSE ("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/MyField1"))1
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| The case of OnStartupComplete | [email protected] | Add-ins for Outlook | 2 | January 14th 09 03:12 PM |
| The case of the disappearing signature | Mike Tordoff | Outlook - General Queries | 3 | March 13th 08 08:03 PM |
| Outlook PST case | tonrado | Outlook - General Queries | 5 | February 22nd 06 04:28 PM |
| How to sychronize in this case: | Josie Walsh | Outlook - General Queries | 2 | February 4th 06 08:22 PM |
| How to sychronize in this case: | Josie Walsh | Outlook - Using Contacts | 2 | February 4th 06 08:22 PM |
Hybrid Mode
