All works fine now. Thanks!



>There're no boolean type in T-SQL. The closest one is bit.

>SELECT CAST(0 AS bit) AS checked,
>...
>

>>Ok, now it doesn't like the 'FALSE'. Whats the correct way to
>>create a boolean column?
>>
>>
>>
>>
>>>Now you have to many commas. Remove the one after the last column.
>>>
>>>>Ok, now it's complaining near the FROM:
>>>>
>>>>

>>>>SELECT FALSE AS checked,
>>>>	  '                    ' AS invoiceid,
>>>>	  '                    ' AS ISCI,
>>>>	  '  ' AS dayofweek,
>>>>	  '          ' AS Phone,
>>>>	  doc.id AS docid,
>>>>	  doc.station,
>>>>	  doc.client,
>>>>	  mod.actual_air_date,
>>>>	  mod.actual_air_time,
>>>>	  mo.show_title,
>>>>	  mo.order_rate AS gross,
>>>>	  mo.program_name,
>>>>	  mo.order_qty AS ordqty,
>>>>	  mo.id AS line_id,
>>>>  FROM Document doc
>>>>  JOIN Client cl ON cl.id = doc.client
>>>>  JOIN Station st ON st.id = doc.station
>>>>  JOIN Media_Order mo ON mo.Document = doc.id
>>>>  JOIN Show_title sht ON sht.id = mo.show_title
>>>>  JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id
>>>>  WHERE doc.id = 14113
>>>>
>>>>