Help :-\

[worldchanger]

Ok I'm trying to do a simple function in SQL. I have the following:

(in microsoft access)
Select fund & '-' & department & '-' & object
From accounts

It produces xxxx-xxxxxx-xxxx


How do I do the same thing in SQL for SQL Server 2000???

 

[swampBoogie]

Select fund + '-' + department + '-' + object
From accounts

 

[tlbroadbent]

Use + instead of & for concatenation in SQL Server. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[nowayout]

Select fund, department, object from Account

 

[nowayout]

oh sorry did not notice '-' it would be as follow

Select fund+ '-' +department+ '-' +object from Account