Quote:
Originally Posted by sarettah
Yeah but that is changing the data in the table and he said he did not want to do that.
.
|
My bad, I got a little lost reading through the replies.
In that case I would explicitly state the columns I'm selecting where one would simply be a string.
ie:
Code:
SELECT column1,column2,'zombie',column4 FROM table;
So instead of pulling data from the 3rd column I'm replacing it with a specific string, or number for that matter.
OOPS, second on the ball.