data type for null in union query

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

I'm attempting to run a union query like this:

SELECT Null as FieldA
FROM Table1

UNION

SELECT NumericField
FROM Table2

Unfortunately, FieldA is returned as a text field, not numeric. Can I add
something to define the proper data type? Flipping the order of the select
statements is not an option. I suppose I could hack and add a select
statement on top like 'Select 0' with a condition that will never occur, but
I'd prefer something more elegant.

Thanks in advance.
 
The workaround you suggest is probably the simplest:
SELECT IIf(False, 1, Null) AS FieldA ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining two tables 2
Union query 5
getting fewer records from a union query than in individual table 5
SharePoint MultiValue Field Data Extraction and UNION Query 2
UNION subquery fails in INSERT statement 2
Union Query 4
Duplicates in union query 3
Union Issue 3

Back
Top