Error 22-322 Expecting format name

[amconnel]

Hi all. 

I am trying to create a computed column in the query builder. I am receiving the error you may see in the photo. I am confused on this error, because I created an identical computation and did not receive the error message (as you can see just below the errors). 

Would appreciate any help on this!
38 QUIT;

[SASKiwi · Accepted solution]

Try adding a full stop on the end of your format: best9.

Format names always include a dot when applying them.

[Kurt_Bremser]

The first format ERROR causes the SQL compiler to ignore the whole SELECT statement, so the second ERROR is not detected.