Combine Fields

Hi there!

I have a table with three columns: Id, Name and Departament. (ex: 23, "Mary", "Check-out")

I'd like to write a SQL Select clause so that the three columns are combined in just one column (ex: "23 - Mary - Check-out")

Is it possible? Many thanks for any kind of help.

Hi,

assuming ID is int

SELECT cast(ID as char(5)) + ' - ' + Name + ' - ' + Department AS TheNameYouLike

FROM YourTableName

|||

try this

SELECT CAST(ID AS varchar(5))+'-'+ltrim(Rtrim(Name))+'-'+ltrim(rtrim(Department) From yourtablename

Madhu