[SOLVED] Append String to SQL value

[maliary]

 

Hello,

 

I have this SELECT datediff(day,1999.03.09,1999.03.19) this returns 10. I would like to append the word day to this result.

 

I have tried this SELECT datediff(day,1999.03.09,1999.03.19)+' '+Days but it doesn't work.

 

Any ideas ?

[Mark Baker]

SELECT CONCAT(datediff(day,1999.03.09,1999.03.19),' Days')

[maliary]

 

It gives an error. Concat is not a recognised built in function name.

[PFMaBiSmAd]

Perhaps if you told us what SQL database type you are using.

[maliary]

 

MSSQL 2005

[mtoynbee]

Try this:

 

SELECT    { fn CONCAT(CAST(DATEDIFF(day, '1999-03-09', '1999-03-19') AS varchar(100)), ' Days') }

 

{edited}

 

or just:

 

SELECT CAST(DATEDIFF(day, '1999-03-09', '1999-03-19') AS varchar(100))+' Days'

[maliary]

 

Thank you very much.

 

That solves it !