Trying to display alias field names

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Trying to display alias field names

Author

Topic

kdnichols
Posting Yak Master

232 Posts

Posted - 2006-11-20 : 11:12:42

Hello All,

I have the following code:


USE MLS
select sc.name,f.field#,fdesc,flong 
from sysobjects so join syscolumns sc
	on so.id = sc.id
	join fld f
	on f.field# = replace(sc.name,'_','')
where so.name = 'dbo.tbl_MLS_Leads_Trans'

I am trying to get the description which is flong and I get the following error message:

Msg 208, Level 16, State 1, Line 2
Invalid object name 'fld'.

What am I doing wrong?

TIA

Kurt

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-20 : 11:15:01

It's either fld does not exists, or you probably need to wrap the column name with brackets f.[field#]

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-20 : 11:15:44

And why aren't you using the information_schema views?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources