Create Expression in View in Enterprise Manager

[bethabernathy]

Hi There - I am trying to create SQL statement in Enterprise Manger where the columns are combined like:

[FirstName] & " " & [LastName] AS Expr1

It gives me the error: "invalid column name".

Is there a way to combine columns that anyone knows of? Thanks, Beth

beth@integratedresourcemgmt.com

 

[JayKusch]

Are you using Enterprise Manager or Query Analyzer ... either way, here is what you may be looking for.

SELECT RTRIM(LTRIM(FirstName)) + ' ' +
RTRIM(LTRIM(LastName)) AS 'FullName'
FROM MyTable

Of course replace MyTable w/ the table you are querying on.

Thanks

J. Kusch