I have two columns say A and B in a table in Sql server 2000
A columns has year data , ex 2008,2009,2007 etc..
B columns has month values ex 1,2,3, .....12
I want to concatenate both fields as YYYYMM , for example 200801,200902...etc.
Please help me out.