Space before table hint

SQL Assistant 4.7.11
MS SQL 2005, MS SQL Server Managment Studio

There is the code:

	Code:
	select * from dbo.Accounts a (nolock)

When I select the code and do the formatting, I get the following

	Code:
	select * from dbo.Accounts a(nolock)

This is that I need, but where the space between table alias "a" and table hint "(nolock)"? Why he is deleted?

My rule for "select":

	Code:
	select ... as ..., ... = ... from ... as ..., ... join ... on ... = ... and ... where ... = ... and ... or ... group by ..., ... having ..., ... order by ..., ...

This is because the syntax is incorrect. You are missing WITH keyword before the hint. Note that using hints without WITH keyword is ok in SQL 2000, partially supported in 2005 and discontinued in 2008

Now, if you want to apply special formatting to a text like WITH (hint here) , you can add your own formatting rule.

	Code:
	WITH (...)

or something similar