D
Daniel L. VanDenBosch
Guest
I would like to be able to
Is there a cleaner way to accomplish this? I feel like I have done this in less characters and in a simpler manner in the past than using a
Continue reading...
SELECT
a NULL value in my SELECT
list so I can use it later in a UNION (for example). When I try SELECT NULL AS my_null_value FROM some_table
it gives me a syntax error. I can work around it by doing the following.
Code:
SELECT CASE WHEN 1=1 THEN NULL END AS my_null_value
FROM some_table
Is there a cleaner way to accomplish this? I feel like I have done this in less characters and in a simpler manner in the past than using a
CASE
statement.Continue reading...