Signed INT 1

[JontyMC]

I have column which is type int. How do I return a signed int in query, ie:

When 0, 0
When -1, -1
When 1, +1
When 123, +123
etc...

Jon

"I don't regret this, but I both rue and lament it.

 

[r937]

select case when daColumn > 0
then '+'+daColumn
else ''+daColumn
end as daFormattedColumn
from daTable

note: daFormattedColumn will be a string

r937.com | rudy.ca

 

[bboffin]

The INT datatype is intrinsically signed. I think what you are trying to do is format the value that has been returned.

I think you can achieve what you want:

case 
when intColName > 0 then '+' + cast(intColName as varchar)
else cast(intcolName as varchar)
end

Bob Boffin