Synametrics Technologies

Greetings,

I'm running into a syntax issue with column aliases, and I'm hoping someone can point me in the right direction.  I'm using the following syntax for a SELECT statement, and it returns the alias properly.

SELECT FNAME AS FirstName

But when I add a space into it, it errors out.

SELECT FNAME AS First Name

I've tried surrounding it in apostrophes, quotes, and brackets, but none seem to be working for me.

Can anyone help me with the syntax for making column aliases with spaces in them in WinSQL?

Thanks,

Adam

Adam,

The answer to this question depends upon the back-end you are connecting to. WinSQL sends your script as-is to back-end and therefore, the script must conform to SQL dialect supported by the RDBMS. For example, if your connecting to MS SQL Server, you could write something like:

SELECT FName as [First Name]

Check the documentation of your RDBMS for a definitive answer.

Did you try tick symbol vs single quotes?  that's the one that tilts to the left on tilde key ` vs ' which is more verical on " key.
SELECT FNAME AS `First Name`;