Comments by krisedison (Top 7 by date)

Please check this http://pastebin.com/sJ6dknEd

The query
select null from information_schema.columns where column_name='Column2'and table_name='TableName'
returns NULL or nothing
BUT the query
SELECT Column1,
CASE WHEN exists (select null from information_schema.columns where column_name='Column2'and table_name='TableName') THEN Column2
ELSE NULL END AS Column2
FROM TableName
didn't work if Column2 doesn't exists. I don't know why....

It says Invalid column name.
I didn't changed column_name because I am trying to look for Column2 in the table but I changed table_name value to the table that it will look for. But still, I have the invalid column error.

Yes it works if Column2 exists but if not it doesn't. I am now looking to use try and catch.