column alias 1

[teser]

How can I create an alias on my SQL:

I tried -
select data as dataalias from table;

Any suggestions?

 

[THoey]

Don't use the "as" statement:

SELECT MyTable.MyField1 LastName,
MyTable.MyField2 FirstName
FROM MyTable Terry M. Hoey

 

[teser]

Thanks

 

[markco]

Another select method:

SELECT column AS "column alias" FROM table;

where
a) column is your target column
b) column alias is your target column alias, you must have " at the begin and end of this alias.
c) table is your target table.