# Syntax error returning calculated field

**URL:** <https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485>\
**Category:** Epicor ERP 10\
**Tags:** baq, sql\
**Created:** [November 21, 2017, 6:29pm UTC](https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485 "2017-11-21T18:29:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![krum](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a88e57/32.png) [@krum](https://www.epiusers.help/u/krum)\
**Post date:** [November 21, 2017, 6:29pm UTC](https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485/1 "2017-11-21T18:29:40Z")

</div>

I’m getting an error when I try to add a calculated field in a BAQ.

> Incorrect syntax near the keyword ‘as’.

The SQL looks right to me, but my SQL is rusty.

```sql
select 
	[OrderRel].[OrderNum] as [OrderRel_OrderNum],
	[OrderRel].[OrderLine] as [OrderRel_OrderLine],
	[OrderRel].[OrderRelNum] as [OrderRel_OrderRelNum],
	[OrderDtl].[PartNum] as [OrderDtl_PartNum],
	[OrderDtl].[LineDesc] as [OrderDtl_LineDesc],
	[OrderDtl].[OrderQty] as [OrderDtl_OrderQty],
	[OrderDtl].[CustNum] as [OrderDtl_CustNum],
	[OrderDtl].[RequestDate] as [OrderDtl_RequestDate],
	[OrderDtl].[NeedByDate] as [OrderDtl_NeedByDate],
	(Part.PartNum is null or Part.NonStock = 1) as [Calculated_MakeToOrder] -- ERROR HERE
from Erp.OrderRel as OrderRel
left outer join Erp.JobProd as JobProd on 
	OrderRel.Company = JobProd.Company
	and OrderRel.OrderNum = JobProd.OrderNum
	and OrderRel.OrderLine = JobProd.OrderLine
	and ( JobProd.JobNum is null )
inner join Erp.OrderDtl as OrderDtl on 
	OrderRel.Company = OrderDtl.Company
	and OrderRel.OrderNum = OrderDtl.OrderNum
	and OrderRel.OrderLine = OrderDtl.OrderLine
left outer join Erp.Part as Part on 
	OrderDtl.Company = Part.Company
	and OrderDtl.PartNum = Part.PartNum
where (OrderRel.Make = 1)

```

Everything else works fine and returns the expected rows. What am I doing wrong with the calculated field?

---

<div class="post-metadata">

**Author:** ![bmgarver](https://www.epiusers.help/user_avatar/www.epiusers.help/bmgarver/32/2867_2.png) [@bmgarver](https://www.epiusers.help/u/bmgarver)\
**Post date:** [November 21, 2017, 6:44pm UTC](https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485/2 "2017-11-21T18:44:45Z")

</div>

case when (Part.PartNum is null or Part.NonStock = 1) then 1 else 0 end

---

<div class="post-metadata">

**Author:** ![krum](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a88e57/32.png) [@krum](https://www.epiusers.help/u/krum)\
**Post date:** [November 21, 2017, 6:53pm UTC](https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485/3 "2017-11-21T18:53:49Z")

</div>

That works after replacing `true` and `false` with `1` and `0`. Thanks.

---

<div class="post-metadata">

**Author:** ![rbucek](https://www.epiusers.help/user_avatar/www.epiusers.help/rbucek/32/28841_2.png) [@rbucek](https://www.epiusers.help/u/rbucek)\
**Post date:** [November 21, 2017, 8:20pm UTC](https://www.epiusers.help/t/syntax-error-returning-calculated-field/41485/4 "2017-11-21T20:20:15Z")

</div>

give Brian a ‘solved’ for is efforts 😉