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!

[Back to original message]