Posted by Rico on 02/14/06 22:01

Hello,

I'm wondering if there is a way to concatenate two fields or a field and a
string value in a single field in a view?

Where in Access I might write;

[field1] & " (m3)" as TotalVolume

is there a way to do this in an SQL Server View?

Thanks!

• Next in forum: Re: Job Executes Only First Step
• Prev in forum: Importing Access database into Sql Server Express
• Thread view: concatenate two fields in a view?

[Reply to this message]