Adding string to a retrieved data in SQL Server

Question

Can any one help me for this:

select round(sum(convert(float, size) / 1024 / 1024 / 1024), 2)

There is nothing wrong with the query. The thing here is, I need output as something like 1 GB like that. Is this possible to get the text 'GB' within the column itself.

Something like this? select CAST(round(sum(convert(float,size)/1024/1024/1024),2) AS VARCHAR) + ' GB' — Fernando Sanchiz
– Fernando Sanchiz, Commented Mar 16, 2016 at 16:00

Neil Hibbert · Accepted Answer · 2016-03-16 16:06:43Z

2

SELECT CAST(round(sum(convert(float,size)/1024/1024/1024),2) AS VARCHAR(20)) + UPPER('gb') AS [Size]

should do the trick...

edited Mar 16, 2016 at 16:06

answered Mar 16, 2016 at 16:01

Neil Hibbert

8625 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

GEEK Over a year ago

How to get them in uppercase. i can't get them. I have tried in many ways

Neil Hibbert Over a year ago

you can force the string to upper case with UPPER(), I have updated my answer to show this. If it still doesn't work, maybe there is something forcing the string to lower-case elsewhere?

SQL Police Over a year ago

Why not write 'GB' instead of upper('gb') ? ;)

Neil Hibbert Over a year ago

@SQLGeorge that's what I had in the original answer, I changed it in the revision to demonstrate the UPPER() function. I appreciate your answer though ;-), because, well, it's en flique...

SQL Police Over a year ago

'en flique' - I will memorize that phrase ;)

Collectives™ on Stack Overflow

Adding string to a retrieved data in SQL Server

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related