This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

What's the name of the `BUILTIN` function that converts `T` and `F` to `true` and `false`?

what am I doing wrong then? :thinking_face: (unexpected error)
```SELECT
	BUILTIN_RESULT.TYPE_BOOLEAN(transaction.posting)
FROM
	transaction```

<@UHXHE0684> I'm not sure - your query works in my account. Perhaps there's a role restriction or permission, or a company feature not enabled? Are you able to run the query as follows?
```SELECT
	transaction.posting
FROM
	transaction```


aha, I was using Tim's sql query tool, which wraps your query in:
```SELECT * FROM ( SELECT ROWNUM AS ROWNUMBER, * FROM ( ${query} ) ) WHERE ( ROWNUMBER BETWEEN ${rowbegin} AND ${rowend} )```
I'm not sql-smart enough to know why this breaks the builtin function, but running the sql string in a script directly has the correct results
Thanks Clay!