How can i add '"-" in column

Posted by jasmeet on Stack Overflow See other posts from Stack Overflow or by jasmeet
Published on 2010-06-18T10:07:31Z Indexed on 2010/06/18 10:13 UTC
Read the original article Hit count: 100

Filed under:
|

my query is showing in row 2000 the data of 2000-2001 & in 2001 the data of 2001-2002. how can i change the column so that it displayes

column 1        column 2
2000-2001         5
2001-2002         3
2002-2003         9
2003-2004         12
.
.
.
.

and so on...

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server