while em using str in my query its showing error, like
select slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate
from GOALSDTL
union
select str((slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate),5,2)
from GOALSDTL_History
error:
doest convert date into int