Hi to all.

At FoodMart , Time dimension.
concat 2 columns "the_month" and "the_year" type of them is "SmallInteger" from table "time_by_day".

I try following (at WinSQL)
Select "the_year" + ' ' + "the_month" From "time_by_day"

It return error.

Q1: How to convert from "SmallInteger" to string?



Have a good day .Ella.

I find CStr().