I'd like to do this, which is perfectly acceptable in SSMS:
<SPAN class="keyword token">SELECT</SPAN> A<SPAN class="punctuation token">,</SPAN> B<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">AS</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> Shape <SPAN class="keyword token">FROM</SPAN> <SPAN class="keyword token">database</SPAN><SPAN class="punctuation token">.</SPAN>dbo<SPAN class="punctuation token">.</SPAN>PARCELS <SPAN class="keyword token">WHERE</SPAN> PID_NUM <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="string token">'someCriteria'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
When I pass this query to MakeQueryLayer_Management it will create the object but no records are returned. If i drop " NULL AS 'C' " the Query Layer will be populated with rows. I am 100% confident my query returns records.
What is the proper syntax in ESRI's implementation of SQL to populate an aliased field with NULL?
