Blank field in query

[getitdaily]

I need to pull field one and field two, with a column in between that doesn't exist anywhere. I would like to add a column in the query and fill it with the value 0.00. How do I do that?

 

[mwolf00]

SELECT field1, 0, field2 FROM myTable -----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com