SQL Syntax

rhender9
rhender9 used Ask the Experts™
on
I'm running the below SQL-T, and I want to hide ColumnA and ColumnB from
the returned record set. As you can see, I'm using A and B to build a String in Column C.

SELECT
COLUMNA,
COLUMNB,
RTRIM(ColumnA) + ' ' + RTRIM(ColumnB)  AS COLUMNC
FROM TABLENAME
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
SELECT
RTRIM(ColumnA) + ' ' + RTRIM(ColumnB)  AS COLUMNC
FROM TABLENAME
Commented:
Hi rhender9,

SELECT
RTRIM(ColumnA) + ' ' + RTRIM(ColumnB)  AS COLUMNC
FROM TABLENAME


Good Luck!

Gary

Author

Commented:
Damn, that was too simple lol

Commented:
A lot of life is simple!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial