Skip to main content
  • EN

A column name that I am trying to SELECT in the SQLExecutor is titled: STATE

The line in the SQLExecutor that contains it is as follows:

I receive an error message that leads me to believe that it is not grabbing this column, and instead trying to grab the alias that I am trying to establish:

Is there a reliable work around for this reserved word?

 

I have tried using the following, to no avail:

pSTATE]

p“STATE”]

/state]

“pSTATE]”

Is State a reserved word?

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql

Try without the [ ]. Else, seems like the issue is somewhere else in your script, like a subquery.

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.