BAQ CALC field char-output of LaborCollection(bollean) HELP!

Epicor ERP 10
1

Epicor SQL formatting within a BAQ is driving me crazy!

The LaborCollection field from labor Head is Bollean (True/False)
Calc-field output vchar = 3 to be “MES” when LaborCollection is TRUE and " " otherwise.

Calc-field Name MES
Data-type nvarchar
format x(3)

CODE??? to achieve this Thanks !

2

Within a BAQ:

case when LaborCollection = 1 then ‘MES’ else ‘’ end

should do it.